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
You can use the function toisodatestring() to convert date into ISO format. This is available in the Date and Time Utilities plugin
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")