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
Wow.....
I hope the alteryx technical team improves this
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?
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