SOLVED
Condition if Time is within a range
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Mario36
8 - Asteroid
‎09-26-2022
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am looking to apply a condition to the attached data where
1. If the time is between 7:00AM and 4:00PM give a result as "Working Hours"
2.If the time is between 4:01PM and 11:59PM then give me "After Working Hours"
3. If the time is between 12:00AM and 6:59AM then give me "Before Working Hours"
Solved! Go to Solution.
Labels:
- Labels:
- Expression
5 REPLIES 5
17 - Castor
‎09-26-2022
07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎09-26-2022
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
dana_mcdonough
Alteryx Alumni (Retired)
‎09-26-2022
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mario36 - take a look at this article which uses the DateTimeParse function: Multiple-IF-condition-for-Date-and-time . This combined with an IF statement should get you what you need!
CarliE
Alteryx Alumni (Retired)
‎09-26-2022
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mario36
Take a look at this workbook
If this helped to solve your problem, please mark it as a solution
Carli
‎09-26-2022
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath Thank you. This helps.
