I’m trying to convert the format of two date columns from Jan 25, 2022 6:11 PM to 2022-01-25 18:11:00
Here is a screenshot of how I have it setup in Parabola…
Even after updating results, the format of the two date columns hasn’t changed. Any suggestions?
Much appreciated.
Hey @eddie - This is interesting. It looks like our format date step is case sensitive in an unexpected way so I will flag this with our engineering team.
In the meantime, if you use a Find/Replace step to replace lowercase “am” “pm” with uppercase “AM” “PM” and then use the Format Dates step as formatted below, that should do the trick! Let us know how that goes.
Thanks @sachi! That did the trick.
The only additional change I had to make was to remove one “d” from the “From this format”. Leaving it as “dd” was causing any single digit date (any day earlier than the 10th of the month) from being formatted (the formatting would fail for that row).
Here is the screenshot of what worked…
Ah, that makes sense! Thanks for following up with the screenshot, @eddie
