How to convert timestamps (date time formats)

[erieqlik]

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]

see this

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


- Regards, Matheus

[Kushal_Chawda]

@erieqlik  try below

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