Date Time Language Help

[dougop]

Hello,

I am trying to get the attached date time formatted into Alteryx's native date time format using Date Time Parse, but I cannot figure our the format for the "language" in the formula.

Any insight here on the language structure would be appreciated!

[alexnajm]

You can use either a DateTime tool or I personally like Formulas! I am not sure if the +00:00 at the end is some sort of timezone offset you need to consider - just let us know (and also provide the data in a format that we can copy paste)

[dougop]

Yes i am writing the formula using Date Time Parse - but i am not sure what the language structure should look like with the attached picture.  Attached is what i have currently and it's not showing as correct

[alexnajm]

I attached my solution above - let me know if it works for your requirements. Otherwise if not, please post the sample data so we can work with it better and let us know what else would be needed. Thank you!

[dougop]

so your solution just snips the last part off - I would like it to be in actual Alteryx date time original format, so I would like to use the Date Time Parse formula.  I have attached the excel for how the date time is coming in.

[alexnajm]

I am confused by your note - Alteryx DateTime format is YYYY-MM-DD hh:mm:ss only. Is there another format you are expecting?

[dougop]

In your solution - the "T" is still present in the middle of the new date time output so its not in the correct format and i will not be able to manipulate the output after using that formula as if it is a date.

[alexnajm]

But my solution doesn't have the T?

[dougop]

interesting - this is the output using your formula in my actual workflow

[Raj · Accepted solution]

use this formual

ToDateTime([Invoice Date])

this will help