Need help explaining the below formula

[chiragpatel_1]

Can someone please explain in very simple terms what the above formula is doing.

Many Thanks.

[mbarone]

Hi @chiragpatel_1 .  I highly suggest you bookmark this page , as you'll refer to it a lot for date/time functions.  Your particular formula appears to be taking a value in field 1, and trying to transform it to a date that Alteryx will recognize (must have format YYYY-MM-DD).  Once it's in that format you can use the various DateTime functions, like DateTimeParse, which is described in detail on the page I referenced earlier.

[atcodedog05]

Hi @chiragpatel_1 

can you provide some sample input data so that we can tell you why/how it's used.

Hope this helps : )