Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Favorite for Incidents created between 6 pm and 5 am

Highlighted
Tracy C_1
Senior Member

Favorite for Incidents created between 6 pm and 5 am

I need to create a favorite for all incidents for the previous day created between the hours of 6 pm and 5 pm.

I found the time function but am not exactly sure how this is utilized.
true and open.time>time(17:00:00) and open.time
1 REPLY
Tracy C_1
Senior Member

Re: Favorite for Incidents created between 6 pm and 5 am

My user figured this out using the tod RAD function and subtracting and adding times for 12:00 midnight.

true and open.time>date(tod())-'7:00:00' and open.time
//Add this to "OnDomLoad" event