I am using JavaScript.
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.
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
That should work, too. Many ways to skin a cat!
Doesn't Time >= '21:00' AND Time <= '02:00' this work. since its a 24 hour time.
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.
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.