Date Parse a String
I have a string in the format = “4-Jul-2017” variable is called “PostingPeriodFormatted”
When I throw on a dateparse method in the mapper like so:
Date.parse($PostingPeriodFormatted, “yyyy MM dd”...
Forum Discussion
i just realized the date parse format is meant to be the format its currently in not what i want to parse it to! when i switched it to dd-MMM-yyyy it works
however does anyone recommend the best way to transform this value coming from a DB: “Jul 4 2017 9:03PM” to 2017-07-04T09:03:00?
Since you are losing the PM designator, wouldn’t the time be 2017-07-04T21:03:00?
I’m conferring with Dev on this right now, so wanted to make sure we parse it correctly.
