Date / Time Formatter Returning Incorrect Data

[CanItBeAutomated]

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!

 

[ArshilAhmad]

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]

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

 

[ArshilAhmad]

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

 

[CanItBeAutomated]

well now dont I feel silly

 

[ArshilAhmad]

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