Issue reading Excel file in Alteryx Cloud: Incorrect date format

[GabrielFernandes]

Hello community, I'm trying to read an Excel file in Alteryx Cloud and it is in the format dd/mm/yyyy, but when I read it in Alteryx Cloud it is becoming mm/dd/yyyy. I've tried several conversions, but it didn't work.

The field is also coming with string

Print ExcelPrint erro

[alexnajm]

Attach the Excel here so we can give you a proper solution!

[GabrielFernandes]

@alexnajm  follow file

[alexnajm]

@GabrielFernandes I read in the file, and I am not seeing the same issue...

[GabrielFernandes]

strange because the correct one is:

08/08/2024
09/08/2024
09/08/2024
08/12/2024
08/12/2024

yours is getting
m/d/y instead of d/m/y

 

[alexnajm]

Very strange indeed - I didn't do anything to your Excel besides open it so maybe it's just regional differences?

Either way, you should be able to convert to a Date data type using that DateTime tool knowing that the format coming into Designer Cloud is mm/dd/yyyy

[GabrielFernandes]

@alexnajm 

I also thought this would solve it but it would return wrong

I tried to force using the format MM/dd/yy
however it comes out with - instead of /

[alexnajm]

That's correct - Dates in Alteryx are always in the yyyy-mm-dd format. You can store dates as a string in the format you want but you'll want it in the yyyy-mm-dd if you want to do DateTime calculations!

I am not sure I understand your ultimate goal - what are you trying to accomplish?

[GabrielFernandes]

Could this be a system error?

the system should allow you to use / since it is in the DATATIME node

I would like to work with data formatted as a date and with "/" if I put it as a string, Excel understands it as text and then I cannot manipulate it effectively

[alexnajm]

That's correct - anything besides yyyy-mm-dd will be treated as Text and behave as such! If you want data to be a Date data type, keep it as yyyy-mm-dd