Date format conversion

[ll98]

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

[Qiu]

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

[echuong1]

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.

[rfoster7]

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]

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

[christine_assaad]

Hi @ll98 

Please check the below. Cheers!