Alteryx Designer Desktop Discussions

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

How to filter on time using 24hr clock

henrymk5
7 - Meteor

I'm having two issues with converting my time and then filtering it

 

#1 - Converting 1:22:08PM time to 24 hour clock 13:22:08

#2 - Once converted I then need to filter my times for everything that is between 1:00AM to 12:00PM and then 13:00AM to 24:00 AM

 

Thanks in advance

2 REPLIES 2
markcurry
12 - Quasar

I think the attached workflow should do it for you....

 

henrymk5
7 - Meteor

awesome, thank you!!!

Labels