DD-MMM-YYYY date not being accepted by Alteryx

[ajaygajree]

Hi All

I have a Date field in my data that is in the format  of DD-MMM-YYYY, when I run my workflow Alteryx Designer is not recognising it as a Date.

I have looked at the Date Parse Function, but I cannot workout how to get Alteryx to accept this as a date.

Any help appreciated!

[MarqueeCrew]

You'll need it in YYYY-MM-DD format for a date

[MattD · Accepted solution]

Hey ajaygajree!

Try using datetimeparse([Date field],"%d-%b-%Y") to parse the date time data type from the string field.

Best,
Matt D

[ajaygajree]

Hi MarqueCrew

Do you mean I have to convert it to YYYY-MM-DD in my Excel file?

Does that not defeat the point of Alteryx!

[ajaygajree]

Thanks MattD

That worked a treat!

[MarqueeCrew]

Date fields in Alteryx have that format. The date parse tool got you there.

[Cen64]

How do I do this if the XLSX file uses Custom dd/m/yy format?

The file type imported is Double - when converting to string in Alteryx the DateTimeFormat displayes null

Thanks

[shahid4280]

 i need to implement the logic inside the query to get

the response as ddmmmyyyy, would be much appreciated if u could help me in this 

<ns2:SampleDate>  {fn:data($FetchingLabInfoOutput/ns1:SAMPLE_DATE)}  </ns2:SampleDate>