Regex my date format

I have been looking at a few regex examples but struggling to get them to work to my particular data. My date data looks like

Jan 5 2017 12:00AM

Jan 20 2017 10:07PM

Jan 21 2017 12:00AM

Jan 1 2017 8:02AM

Feb 4 2018 3:15PM

I need to convert this to a date, also converting the time to 24 hour format. Any idea?

Thanks

Roger

Regex

Accepted answers

BenMoss

Should be relatively straight forward.

Use the 'Date time parse' tool and type in a custom expression at the bottom which would be

%b %d %Y %I:%M%p

Example attached.

Ben

Date Time Convert.yxmd

All comments

BenMoss

Should be relatively straight forward.

Use the 'Date time parse' tool and type in a custom expression at the bottom which would be

%b %d %Y %I:%M%p

Example attached.

Ben

Date Time Convert.yxmd

RogerA

Thanks Ben that's worked perfectly. Can you explain the logic in the query? I can figure out the % but what is th "b" and how does it convert AM PM to 24hr?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280