Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Hi, I'm trying to split the given date format "2/09/2019 8:42:00 AM" into columns

"2/09/2019"

"8:42:43 AM"

Can someone pls assist with the formula, thanks

1 REPLY 1

Split the date-time into columns using Text to Columns tool by setting the delimiter as \s (Space).

Hope the attached workflow will help you.

Date Time