topic DefinitionExpression without or in ArcGIS JavaScript Maps SDK Questions

DefinitionExpression without or

RickeyFight — Wed, 03 Jun 2015 15:46:33 GMT

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).

ChrisSmith7 — Thu, 04 Jun 2015 14:55:39 GMT

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.

thejuskambi — Thu, 04 Jun 2015 16:12:13 GMT

Doesn't Time >= '21:00' AND Time <= '02:00' this work. since its a 24 hour time.

ChrisSmith7 — Thu, 04 Jun 2015 17:17:33 GMT

That should work, too. Many ways to skin a cat!

RickeyFight — Thu, 04 Jun 2015 17:22:36 GMT

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

RickeyFight — Thu, 04 Jun 2015 17:47:37 GMT

I thought of another way that does work:

NOT Time BETWEEN '03:00:00' AND '21:00'

Thank you both for your input.