Question

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

Forum|Forum|10 months ago
September 29, 2025
7 replies
0 views

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?

shubhama926776

Try using this

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

nupoorg186699Author

I have already tried it, it is using "Z" to display timezone

shubhama926776

oh then use

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

harshas2775

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

nupoorg186699Author

Using toisodatestring() we are getting date in this format "2025-09-29T11:52:18.090Z"
We have a char length limit, so need to remove after "."
do we have any function which will return just "2025-09-29T11:52:18Z" ?

nupoorg186699Author

for now I have configured as which is working fine [mention:65b14048184a4eb5aff3a76c87b97431:e9ed411860ed4f2ba0265705b8793d05]
concat(left(toisodatestring(now()),19),"Z")

Thanks for your help [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Sign up

Login with SSO

Login to the community

Login with SSO