I am looking for a way to write:
Time >= '21:00'AND Time <= '23:59:59' OR Time >= '00:00:01' AND Time <= '02:00'
Without an OR statement.
What I really need is time (9pm-2am).
I thought of another way that does work:
NOT Time BETWEEN '03:00:00' AND '21:00'
Thank you both for your input.
Rickey, I haven't tried this; however, I believe you may be able to use the BETWEEN operator:
Time between '21:00:00' and '02:00:00'
Try that and see if it works.
Doesn't Time >= '21:00' AND Time <= '02:00' this work. since its a 24 hour time.
That should work, too. Many ways to skin a cat!
thejus and Chris,
Neither of these returns results. I am using this in a definitionexpression.
They both work for times that are within 24 hrs. Such as 6am-8pm
The OR statement works but for some reason that messes up the rest of the definitionexpression
Retrieving data ...