I am trying to convert a date field from Excel from Jan-01-2018 12:03AM to the Alteryx format of 2018-01-01 00:03:00. I have tired the DateTime Tool as well as the DateTimeFormat function with no success. Get various error messages but no results. Any suggestions will be appreciated.
Solved! Go to Solution.
Try this:
DateTimePARSE([Field1],'%b-%d-%Y %H:%M%X')
Replace [Field1] with your field.
This worked for me in an example. The TIME functionality in particular is fairly complex due to the "Output Only" configuration options.
DateTimeParse([Date],"%b %d %Y %I:%M%p")
That should work with the format of: "Jan 22 2018 12:13AM"
Cheers,
Mark
you added a colon to my formula!
DateTimeParse([Date],"%b %d %Y %I:%M%p")
the incoming data doesn't look like:
"Jan 22 2018 12:13:AM"
please try again.
No worries. :)
Cheers,
Mark
I am facing issues to get a similar expression for 'yyyy-mm-ddThh:mm:ss.sssZ' format.
My source field is in date(YYYY-MM-DD) format and destination field needs to be in above format for salesforce.
Any suggestions will be appreciated.