Can someone please explain in very simple terms what the above formula is doing.
Many Thanks.
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.
can you provide some sample input data so that we can tell you why/how it's used.
Hope this helps : )