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

[GabrielFernandes]

Wow.....

I hope the alteryx technical team improves this

[alexnajm]

I am not sure I agree - this has been a consistency since Alteryx has been released to ensure dates are treated carefully. There are too many formats out there (dd/mm/yyyy, mm/dd/yyyy, dd/mm/yy, Month dd, yyyy, etc) so this ensures a standard!

Have you tried outputting it?

[GabrielFernandes]

but in the DATETIME node it shows that I can use "/" as a separator, but when selecting it it stays as "-" and does not let the user save it as "/"

I think there's something wrong

And also because it is reading my base as mm-dd-yy and when I open Excel it is with dd/mm/yy