Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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