Find event every days betwen 10:50 PM and 01:30 AM

[yoan]

Hello, I didn't find the correct way to search specific events between specific hours.

I want to find since the last 7 day between 10:50 PM and 01:30 AM

Thank's

[yoan]

Thank's it's work

[rnowitzki · Accepted solution]

Hi @yoan ,

Maybe there is a more direct approach, but this should work.

| where date_hour=22 OR date_hour=23 OR date_hour=0 OR date_hour=1 
| where NOT (date_hour=22 and date_minute<50) 
|  where NOT (date_hour=1 and date_minute>30)

 
BR

Ralph