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?
Discussion posts and replies are publicly visible
Try using this
text(todatetime(yourdatetime), "yyyy-MM-dd'T'HH:mm:ss'Z'")
You can use the function toisodatestring() to convert date into ISO format. This is available in the Date and Time Utilities plugin
I have already tried it, it is using "Z" to display timezone
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" ?
for now I have configured as which is working fine Harsha Sharma concat(left(toisodatestring(now()),19),"Z")
Thanks for your help
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")
oh then use
concat(text(togmt(now()), "yyyy-MM-ddTHH:mm:ss"),"Z")