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.

Date format conversion

ll98
9 - Comet

I received a file with the following date format    Dec 1-22,20 --- How do I convert to MM/DD/CCYY ?

 

Although the file date filed is a range field - Dec 1 - 22   I just need to capture the 22nd (after the hyphen)

 

MM   :  12

DD :  22

CCYY : 2020

 

12/22/2020

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@ll98 
I used RegEx with some consideration of some dynamic.

0115-II98.PNG

echuong1
Alteryx Alumni (Retired)

I'd parse out the individual pieces with text to columns, then use a formula to clean up and concatenate the pieces. I converted it to a proper date with a Select.

 

echuong1_0-1610662831497.png

 

rfoster7
9 - Comet

Question: Do you have any records that bridge over a month. Your example is Dec 1-22,20. But do you have anything like Mar 27-13,20 indicating March 27th to April 13th.

 

When I've received data with that format, I found instances like that. That would be harder to work around if you have it. 

Qiu
20 - Arcturus
20 - Arcturus

@ll98 
Appreciate if you would mark the answer as acccept if you find it useful.😁

Hi @ll98 

 

Please check the below. Cheers!

christine_assaad_0-1610663555287.png

 

Labels