topic Re: How to convert timestamps (date time formats) in App Development

How to convert timestamps (date time formats)

erieqlik — Thu, 10 Oct 2024 17:54:08 GMT

I have a timestamp I retrieve from JIRA Align. Example: 2024-10-05T16:21:47.733Z

I want it in the format: MM/DD/YYYY hh:mm:ss Example: 10/05/2024 16:21:48

How do I do this?

How would I do it to accommodate AM/PM?

MatheusC — Thu, 10 Oct 2024 20:59:51 GMT

see this

TimeStamp(YourDatetime,'MM/DD/YYYY hh:mm:ss TT')

- Regards, Matheus

Kushal_Chawda — Fri, 11 Oct 2024 15:35:17 GMT

@erieqlik try below

timestamp(Timestamp#(TimeField,'YYYY-MM-DDThh:mm:ss.fffZ'),'MM/DD/YYYY hh:mm:ss')