Service Desk Practitioners Forum
cancel

Favorite for Incidents created between 6 pm and 5 am

Highlighted
Tracy C_1
Honored Contributor.

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
Honored Contributor.

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