Data String "01-JAN-17" convert to Date format. Thank you.

Hi Alteryx Gurus,

I am very new beginner with Alteryx... and now I am trying to build a user case.

I have a challenge time to convert a date field, the data is shown as " 01-JAN-2017" and I need to convert it into normal date format.

I tried DateTimeFormat([GL_DATE],"%m%d%y") and DateTimeParse.. Both seems not work, and returns null values.

Anyone could kindly provide some guidance on this issue?

Any help is appreciated very much.

Thank you,

Flora

Date Time

Accepted answers

MarqueeCrew

You'll need to define a new field as DATE. Your incoming "date" field is being read in as a STRING.

DateTimeParse([GL_DATE],"%d-%b-%Y")

Screen Shot 2017-02-16 at 2.48.43 PM.png

Cheers,

Mark

All comments

MarqueeCrew

You'll need to define a new field as DATE. Your incoming "date" field is being read in as a STRING.

DateTimeParse([GL_DATE],"%d-%b-%Y")

Screen Shot 2017-02-16 at 2.48.43 PM.png

Cheers,

Mark

florayaoyao

Hi Mark,

This works perfectly! Thanks a lot!

Flora

florayaoyao

Hi Mike,

May I ask a further question regarding the use of DateTimeParse ?

So what do I exactly to put in the " ", should it be the format of the existing field, in this case [GL_Date] or the output format I want?

I also find out there is another function int Altyerx called "DateTime" under Parse. Will this function also help me to solve the problem? just wondering.

So grateful for your knowledge.

Thank you,

Flora

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703