Free Trial

Alteryx Designer Desktop Discussions

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

Datetime data change error

Grantham
6 - Meteoroid

Hello All

 

Why does the Datetime out change the month data from the input to output?

 

 

 

Grantham_0-1661720103965.png

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Grantham 
Can you provide a snapshot showing that how the DateTime Tool is configured?

flying008
15 - Aurora

Hi, @Grantham 

 

I guess you used a custom format code: %Y-%M-%d  or %Y/%M/%d
And the correct code should be: %Y-%m-%d or %Y/%m/%d

So you have to pay attention to the difference between upper and lower case.

liwagab
6 - Meteoroid

Based from your input you have to specify the format of the incoming text.

yyyy/MM/dd should fix this (case sensitive)

 

liwagab_1-1661755472977.png

 

 

Labels
Top Solution Authors