Date/Time Parse

[Scott_data]

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!

[Scott_data]

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!

[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 : )

[Scott_data]

I need to be able to split both of the columns with date/time in so that my team can filter by the date the customer first booked their appointment. 

[atcodedog05 · Accepted solution]

Hi @Scott_data 

Here is how you can do it.

Workflow:

Hope this helps : )

[RolandSchubert]

Hi @Scott_data ,

you can convert the string to a date and a time column in the respective date or time data type:

Let me know if it works for you.

Best,

Roland

[binu_acs]

@Scott_data Another option using RegEx formula

[Scott_data]

Amazing thank you!

[Scott_data]

Thank you all! 

[atcodedog05]

Happy to help : ) @Scott_data 

Cheers and have a nice day!