Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

DATE FORMAT

Gratus_tz
7 - Meteor

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.

2 REPLIES 2
Raj
16 - Nebula

@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
13 - Pulsar

@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.

Labels
Top Solution Authors