Date Time Language Help

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!

Capture.PNG

Date Time

Accepted answers

Raj

use this formual

ToDateTime([Invoice Date])

this will help

All comments

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)

Date Time Language Help.yxmd

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

Capture.PNG

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.

Book11.xlsx

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.