Date format change in Alteryx

[faisal9999]

I have data set in xlsx format. Opening file date column data type is Date by default but I have data in date column like below

01/01/2019

Hardcode the value

(Blank)

But when I put this in Alteryx this column's data type coming as "Vstring" and data is coming like

1899-12-31

Hardcode the value

Blank

My date is getting convert from 01/01/2019  to 1899-12-31

any idea how can see my original date in Alteryx.

[binu_acs · Accepted solution]

@faisal9999 the year part of your date is 20219 which is not a valid year, 

[flying008]

Hi, @faisal9999 

FYI.

[faisal9999]

My bad I have rectify the date

[flying008]

Hi, @faisal9999 

If you get your want, please mark above both posts as solution and give a like for more share.