Filter by hours

[brispannaus]

Hi,

I'm trying to filter out all the changes that happen between a certain time, but right now the only option I have is to filter out by day and inside the day between the hours. But in that case I would have to filter each of the 365 days between the hours.

For example, I need to have all changes that are between 00:00 and 08:00, regardless of day. Is that possible? 

Thanks in advance!

[AndersBGS]

Hi @brispannaus ,

Yep, you can utilize the "trend" operator: 

If my answer has helped with your question. please mark my answer as accepted solution and give a thumb up.

Best regards
Anders 

[brispannaus]

Thanks Anders for the reply. What if I need to have the window be from 12.30 to 5.30 for example? 

[AndersBGS]

Hi @brispannaus ,

I would assume as there is no half hours OOTB, then you need to create a script include and call the script include in the report condition according to: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0832058

If my answer has helped with your question. please mark my answer as accepted solution and give a thumb up.

Best regards
Anders