Date/Time Parse

Hello Alteryx community!

I'm having trouble splitting a date/time column into 2 separate columns. The format of the date changes. Example below. The trouble I am having is the number of characters changes on the day of the month and then the time. If it was Jan 01 2022 I'd be ok. Same for the time, it changes from 2 number format (12:55PM) to 1:09PM.

Any help is much appreciated!

Parse

Accepted answers

atcodedog05

Hi @Scott_data

Here is how you can do it.

Workflow:

Hope this helps : )

Split.yxmd

All comments

atcodedog05

Hi @Scott_data

Can you provide some sample input and expected output in an excel file. It will help us get a better understanding of the usecase.

We will be happy to help : )