Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Date Format Issues

shashank_shukla
8 - Asteroid

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

 

6 REPLIES 6
IraWatt
17 - Castor
17 - Castor

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:

Animation.gif

Any questions or issues please ask :)
HTH!
Ira

 

LouisJ
8 - Asteroid

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

Emmanuel_G
13 - Pulsar

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.

 

Emmanuel_G_0-1658136175175.png

 

binuacs
20 - Arcturus

@shashank_shukla one way of doing this

binuacs_0-1658136460125.png

 

 

shashank_shukla
8 - Asteroid

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
13 - Pulsar

@shashank_shukla Welcome !

Labels