Format Date & Time to Zulu

Hello,

I am trying to convert a date into zulu format, however I am having trouble with the am/pm part.
For example, I would like June 4, 2020 - 4:00pm to be converted to 2020-06-04T16:00 however what I am getting is 2020-06-04T04:00.

Is there any way to have the conversion take into account am/pm?
Thanks!

Hi @Ilias_Ettayebi - Date formatting is always a little tricky! It looks like your Old Format and New Format need slight edits.

Try this for Old Format:
MMMM D, YYYY - h:mma

Try this for New Format:
YYYY-MM-DDTHH:mm

Let me know how that goes!

1 Like

Thank you very much @sachi, it worked perfectly!!

I just noticed from the Date Formatter page that HH is for 24 time where as hh is for 12 hour time, which now makes sense!

Thanks again :slight_smile:

2 Likes

No problem! Glad it worked.

2 Likes