Skip to main content
nupoorg186699
Participating Frequently
Sep 29, 2025 10:18 AM UTC
Question

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

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? 

7 replies

shubhama926776
Brainy
Sep 29, 2025 10:41 AM UTC

Try using this

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

शुभम्
nupoorg186699
Participating Frequently
Sep 29, 2025 11:51 AM UTC

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

shubhama926776
Brainy
Sep 29, 2025 12:12 PM UTC

oh then use

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

शुभम्
harshas2775
Brainy
Sep 29, 2025 11:42 AM UTC

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

Happy to help. Even happier to optimize.
nupoorg186699
Participating Frequently
Sep 29, 2025 11:55 AM UTC

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" ?

nupoorg186699
Participating Frequently
Sep 29, 2025 11:56 AM UTC

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]