Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Date Time

mnhhs
7 - Meteor
‎12-01-2019 08:36 PM

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

 

Labels:
Reply
0
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
meeravijayan2011
8 - Asteroid
‎12-01-2019 08:40 PM

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.yxmd
Reply
0
0 Likes
Labels