Date Format Issues

[shashank_shukla]

Hello,

In the case I'm working on, I need to pull the data from an Excel file. I have a Date column with date data and an unfixed format in the input file. I can only import the data into Alteryx's default format.

I'll mention the example data below.

Input                   Output

2022-06-20          2022-06-20

2022-07-15          2022-07-15

2022-08-09          2022-08-09

2022-09-03          2022-09-03

2/31/2021            2021-02-31

5/18/2019            2019-05-18

6/22/2018            2018-06-22

Kindly help me to get the solution.

If possible then send me sample workflow as well.

Thanks And Regards,

SHASHANK R. SHUKLA

[IraWatt · Accepted solution]

Hey @shashank_shukla,

Some sample data would be great. The simplest way I know to convert your input column to date output column would be to just use DateTime Tools to parse individual date formats then combine them at the end into one column like this:

Any questions or issues please ask :)
HTH!
Ira

[LouisJ]

And please check if you have the 31st of February in your actual data ! Not a good sign haha

[Emmanuel_G · Accepted solution]

Hi @shashank_shukla ,

One way to do this in one tool.

Be careful to the date on line 5 ( 31 Feb ). I edit to replace with 28.

[binuacs · Accepted solution]

@shashank_shukla one way of doing this

[shashank_shukla]

Hello @binuacs @Emmanuel_G @LouisJ @IraWatt ,

The Actual data contains the wrong input for February month. That's the reason My logic was getting failed.

Thank you very much for your help.

Have a great day ahead of you.

Thanks And Regards,

SHASHANK R. SHUKLA

[Emmanuel_G]

@shashank_shukla Welcome !