Data conversion for V_string to date - does not work

[rlopez]

Hi All,

I have a date coming in via Excel as Sep 6, 2019, 10:03:35 AM. It is accepted into Alteryx as a V_string. I need to convert it to a date in yyyy-mm-dd format.

Converting via Select tool or the DateTimeParse (tried DateTimeParse([Raw Date],"%Y/%m/%d")) results in nulls. What else can I do?

Thanks in advance,

Rosa

[danilang · Accepted solution]

Hi @rlopez 

You need to change the format string "%Y/%m/%d" to match the format of the date.  In your case  it will be 

DateTimeParse([RawDate], "%b %d, %Y, %I:%M:%S %p") 

Check this page for a list of the various format options

Dan 

[RolandSchubert · Accepted solution]

Hi Rosa,

try DateTimeParse([Raw Date],"%b %d, %Y")

%b is the abbreviated month name.

Best regards

Roland

[rlopez]

Thank you very much! Both solutions works!