I am using JavaScript. I am looking for a way to write: Time >= '21:00'AND Time = '00:00:01' AND Time <= '02:00' Without an OR statement. What I really need is time (9pm-2am).

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DefinitionExpression without or

RickeyFight

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

タグ付けされた投稿をもっと見る

Accepted answers

RickeyFight

I thought of another way that does work:

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

Thank you both for your input.

All comments

RickeyFight

I thought of another way that does work:

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

Thank you both for your input.

RickeyFight

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

ChrisSmith7

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

thejuskambi

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

ChrisSmith7

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.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.