Converting string (dd-MON-yyyy hh:mm PM) to date

Hello,

I have a string field that I'm trying to convert to a date. An example of one of the strings is 13-DEC-2019 04:09 PM. I am trying to convert the string to a date/time field, but I cannot seem to get the time to work correctly. If is use the DateTime tool, it will convert all times to AM. I have also tried to use DateTimeParse, but I cannot get the AM/PM portion to work correctly there either.

Any suggestions?

Date Time

Accepted answers

fmvizcaino

Hi @StephenMcRaney ,

You can use the DateTimeParse function using the formula tool as example attached.

DateTimeParse([Field1],'%d-%b-%Y %I:%M %p ')

You can find all specifiers at https://help.alteryx.com/2019.4/Reference/Functions.htm

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-23 Converting string (dd-MON-yyyy hhmm PM) to date.yxmd

echuong1

Try using the datetime tool with the following configuration:

%d-%b-%Y %I:%M %p

New Workflow2.yxmd

estherb47

Hi @StephenMcRaney !

Have you tried %p as the qualifier for AM/PM? I believe that the AM/PM needs to be capital letters in your data for it to work.
In a formula tool, this should work:
DateTimeParse([Date],"%d-%b-%Y %I:%M %p")