Date with month format conversion issue

Hi,

I have date in excel xls file, when imported to Alteryx is of V_Wstring format. The date is in the format '28-Oct-20'. I am trying to convert it into '2020-10-28' using DateTimeParse([Date],"%Y-%m-%d") . All the values have turned into null.

Can someone please help.

Date Time

Data Investigation

Accepted answers

atcodedog05

Hi @hegdepavithra10

Try

DateTimeParse([Date],"%d-%b-%y")

Here is a workflow:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

date.yxmd

All comments

atcodedog05

Hi @hegdepavithra10

Try

DateTimeParse([Date],"%d-%b-%y")

Here is a workflow:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

date.yxmd

hegdepavithra10

@atcodedog05 Thank you . This definitely helped. But if you do not mind could you explain the logic

atcodedog05

Sure @hegdepavithra10

Basically in DateTimeParse() function you need to give the format in which your input text is in.

Here its 28-Oct-20 and pattern for it is %d-%b-%y.

%d- date

%b- month in text like Oct. If it was in number like 10 it would be %m

%y- year

so pattern %d-%b-%y

Hope this helps 🙂

atcodedog05

Happy to help 🙂 @hegdepavithra10

Cheers and Happy Analyzing 😀

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703