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.
SOLVED

Date/Time Parse

Scott_data
5 - Atom

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_0-1644413015858.png

 

8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova

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
5 - Atom

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
22 - Nova
22 - Nova

Hi @Scott_data 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644414751799.png

 

Hope this helps : )

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @Scott_data ,

 

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

 

2022-02-09_14-42-10.jpg

Let me know if it works for you.

 

Best,

 

Roland

binuacs
20 - Arcturus

@Scott_data Another option using RegEx formula

 

binuacs_0-1644414520710.png

 

Scott_data
5 - Atom

Amazing thank you!

Scott_data
5 - Atom

Thank you all! 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Scott_data 

Cheers and have a nice day!

Labels