DateTime Function Error

[Athul]

Hi all,

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

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

Can you provide a solution for this problem?

Thanks in advance!

[GiuseppeC · Accepted solution]

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:

Hope this helps!

Giuseppe

[Athul]

Hi @GiuseppeC 

Thanks for the solution. It absolutely works. 

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!!

[GiuseppeC]

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

Best,

Giuseppe