Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Language Help

dougop
7 - Meteor

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!

13 REPLIES 13
alexnajm
18 - Pollux
18 - Pollux

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

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
18 - Pollux
18 - Pollux

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

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
18 - Pollux
18 - Pollux

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

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
18 - Pollux
18 - Pollux

But my solution doesn't have the T?

Date Time Language Help Pic.PNG

dougop
7 - Meteor

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

Raj
16 - Nebula

use this formual

ToDateTime([Invoice Date])

this will help

 

 

Labels
Top Solution Authors