Is "YEAR-MM-DD" only date format that Alteryx recognizes?

[hlee36]

When I tried to convert string of "2020-JUN-08" to date value, it was converted into "null".

I had to use formulas and stuff (a little time-consuming) to convert the string of "2020-JUN-08" into a string of "2020-06-08". Then, I was able to convert this string into date value.

My question is, is this format "YEAR-MM-DD" the only date format that Alteryx recognizes?

[FrederikE]

Hey @hlee36,

Yes. Sadly there is no further auto-detection to get other date types. 

[caltang]

Yes, unfortunately that is the case. Just a side note, if you're dealing with bigger data sets that are less well kept, you may encounter differences in how users input dates, and one format may not fit all in Alteryx too. 

Need to get a little creative in ensuring all types of dates are accounted for properly.

[MarqueeCrew]

@hlee36 ,

 the ISO standard format is used.  Here is a page to bookmark: https://help.alteryx.com/20231/designer/datetime-functions#specifiers 

you can use this function to convert your data:

DateTimeParse("2020-JUN-08","%Y-%h-%d")

 used as a variable it looks like:

DateTimeParse([yourDateField],"%Y-%h-%d")

I hope that this helps.  If you would like to modify or enhance Alteryx behaviors, you should checkout the ideas 💡 posts here:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/idb-p/product-ideas 

cheers,

Mark