2 of 2 people found this helpful
Hi Dan! Try putting [DateTime] (or whatever your date-time field is called) into the filters as "Individual Dates and Times".
Then, go into the Condition tab and put this into the "By formula" window:
(DATEPART('hour', [DateTime]) = 7 AND DATEPART('minute', [DateTime]) >= 30)
(DATEPART('hour', [DateTime]) > 7 AND DATEPART('hour', [DateTime]) < 15)
(DATEPART('hour', [DateTime]) = 15 AND DATEPART('minute', [DateTime]) < 30)
Of course, replace [DateTime] with your field name. Was it [Surgical Start Time]?
In case you're missing some entries, you might need to also go to the General tab and check "Use all".
This appears to have worked for the timeframe. Now I can just ad DOW and filter out Sun and Sat. Thanks David, this appears to work so far...
That's great! I'm happy to help. Let me know if you run into any issues!
Hi Dan, I've just sent you an email. Please let me know if you don't receive it, and I can try again.