European vs US date formatting

[daniele_zatti]

Hi All,

i have an excel file generated by an ERP report that has dates formatted according to European standard (DD/MM/YYYY). However since my Excel is set up on US standard, when i try to import it in Alteryx, all the dates where the day is <=12 are automatically formatted as dates but day and month are flipped. All dates that have day >12 are not recosgnized as dates. Example (see also screenshot attached):

2 July 2024 ==> recognized as date, but formatted as 7 February 2024

30 June 2024 ==> not recognized as date

I tried to dig through some similar discussions and tried using FORMULA with an IF on DATETIMEPARSE, but it didn't work. I was trying something similar:

DateTimeFormat(if IsNull(DateTimeParse([Data contabile], '%Y-%m-%d')) then DateTimeParse([Data contabile], '%d/%m/%Y') else DateTimeParse([Data contabile], '%d-%m-%Y') endif,'%Y-%m-%d')

Thanks for any help here.

Daniele

[Qiu]

@daniele_zatti 
Can you share a sample Excel Input?
My idea is to bring the data including header then do the parsing.

[daniele_zatti]

Sure, please see attached.

[Raj · Accepted solution]

@daniele_zatti 
find the workflow attached
mark done if solved.

[daniele_zatti]

Works neatly, thanks!