Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Issue reading Excel file in Alteryx Cloud: Incorrect date format

GabrielFernandes
7 - Meteor

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 ExcelPrint erroPrint erro

12 REPLIES 12
GabrielFernandes
7 - Meteor

Wow.....

I hope the alteryx technical team improves this

alexnajm
17 - Castor
17 - Castor

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
7 - Meteor

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