DATE FORMAT

[Gratus_tz]

Hi Everyone,

I am Encountering a challenge where the Format of Date that I have inserted on my Data which is dd/mm/yyyy keeps changing when i import the Data to Alteryx to the Format yyyy-mm-dd. Can someone tell me why is it happening.

[Raj]

@Gratus_tz 
the date format used in alteryx is YYYY-mm-dd
so you are getting this changes

if required you can change them in alteryx

hope this helps
mark done if solved.

[OTrieger]

@Gratus_tz 

There are 2 things here, date format of your excel and that will changed based on your regional setting, and the default date format in Alteryx.

Date format in Alteryx as @Raj mentioned in YYYY-mm-dd. So if you would like that Alteryx will recognize the data as date, this is the needed format. There are ways how to convert string to date.

When you import the data into Alteryx, when Alteryx is recognizing the data as date it will set it automatically to the default format. Now, if your excel regional setting is set to dd/mm/YYYY you do not need to do anything, as when you will write out the data and open the file in excel you will see that format.

Nevertheless if your excel regional format is not as expected output, just set the expected output in Alteryx as string and then it would be handled.