community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Parsing Non-English Date String

I suggest to add the functionality to parse date strings containing non-English month/day names into Date format

Maybe by detecting the display language of Windows or the language of the DateTime format in Windows settings.

 

For example, right now in Alteryx, DateTimeParse('July 2008','%B %Y') works fine, but for French month name, DateTimeParse('Juillet 2008','%B %Y') returns null !

and when calling DateTimeFormat(DateTimeNow(), '%B') we would like to have "Juillet" instead of "July" for French version of Windows/DateTime settings.

 

Right now, we need to use workaround solutions like SWITCH to solve this issue!