Date / Time Formatter Returning Incorrect Data

Status: Closed · Asked by Aaron Watkins on · 0 views

CanItBeAutomated — Question ·

I am trying to convert a date/time stamp to the proper format for the application I am sending it to.

While the date going in is January 21st, the date coming out... Is January 4th,.

Help!

Arshil Ahmad — Reply ·

Hi @CanItBeAutomated,

Change the 'From Format' to 'MM/DD/YYYY hh:mm A' instead of 'DD/MM/YYYY hh:mm A'. This will fix your issue

CanItBeAutomated — Reply ·
Hi @CanItBeAutomated,

Change the 'From Format' to 'MM/DD/YYYY hh:mm A' instead of 'DD/MM/YYYY hh:mm A'. This will fix your issue

Hi @ArshilAhmad - if you look at the screenshot you can see that it IS already MM/DD/YYYY not DD/MM/YYYY

Arshil Ahmad — Reply ·

It's DD/MM/YYYY in the screenshot you have shared.

CanItBeAutomated — Reply ·

well now dont I feel silly

Arshil Ahmad — Reply ·

We all have our moments. It's all good!

Back to all forum threads · Log in to reply