community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

DateTime Function Error

Meteoroid

Hi all,

Recently I found a problem with the Date-Time function. 

DateTime.JPG

 

The month part of the date gets shifted back by 2 months.

 

Can you provide a solution for this problem?

 

Thanks in advance!

Alteryx
Alteryx

Hi @Athul,

 

Are you using the DateTime tool to do the conversion from string to datetime? If so, can you please post the configuration that you are using? This could be do to a misconfiguration of the format (the box titled "Select the format that matches the incoming string field".

 

This should give you what you need:

 

Capture.PNG

Hope this helps!

Giuseppe

 

Meteoroid

Hi @GiuseppeC 

 

Thanks for the solution. It absolutely works. asd.JPG

 

I just found out that we have to type "yyyy.MM.dd" to get the correct output. As you can see What i have done is "yyyy.mm.dd" thus getting the wrong output. Thanks for your help!!

Alteryx
Alteryx

Ah! Just an oversight, glad it worked! Thanks for letting me know, @Athul!

 

Best,

Giuseppe

Labels