How to format time in ISO format "2025-04-02T15:57:77Z" in Appian?

Question

Hi all, 
 I have an API to call from our application, in which we need to send message timestamp in ISO UTC format "2025-04-02T15:57:77Z" 
 So now apart from formatting the date time with concatenating T and Z, do we have any other function which can directly convert time to this?

Harsha Sharma · Accepted Answer

Glad it worked! Alternatively instead of using value '19' you can split using dot(). and append 'Z' to first string also. 
 concat(split(toisodatestring(now()),".")[1],"Z")

Nupoor · Answer

for now I have configured as which is working fine Harsha Sharma concat(left(toisodatestring(now()),19),"Z") 
 Thanks for your help

Shubham Aware · Answer

oh then use concat(text(togmt(now()), "yyyy-MM-ddTHH:mm:ss"),"Z")

Shubham Aware · Answer

Try using this text(todatetime(yourdatetime), "yyyy-MM-dd'T'HH:mm:ss'Z'")

Harsha Sharma · Answer

You can use the function toisodatestring() to convert date into ISO format. This is available in the Date and Time Utilities plugin

How to format time in ISO format "2025-04-02T15:57:77Z" in Appian?

Top Replies