How to check Time if it Falls in a Certain Range

Hi! I'm stuck on a challenge here: I have a time and I want to check if it falls from a certain time range.

I want to check if those times falls inside 10PM - 6AM.

Please Help,

Thanks!

Date Time

Accepted answers

Since you want to look for values between 10 PM and 6AM remove the last 06 from @vishwa_0308s' solution

As a single formula that you could put in a Filter tool, the expression would be

ToNumber(Left([Field1],2)) in (22,23,0,1,2,3,4,5)

Dan

Check the data type. And the use datetime parse and formula tools to achieve.

One very simple logic:

Just extract the hour value in a variable say [Hour] using left function and put those hours in your filter.

Like in your case : [Hour] in (22,23,00,01,02,03,04,05,06)

Since you want to look for values between 10 PM and 6AM remove the last 06 from @vishwa_0308s' solution

As a single formula that you could put in a Filter tool, the expression would be

ToNumber(Left([Field1],2)) in (22,23,0,1,2,3,4,5)

Dan