Report tickets opened between the hours of 6 PM and 5:00 AM for the last year,

B Ashok
Tera Guru

Hello Team, 

 

 I need to report specifically  any tickets opened between the hours of 6 PM and 5:00 AM for the last year, as well as any ticket opened on Saturday and Sunday.


I know how to report on date ranges with the 'Opened' criteria, but I don't see how to report on a specific time range within a date range or to specify weekends only.


Any help would be appreciated!

 

Thanks

Ashok 

1 ACCEPTED SOLUTION

Peter Bodelier
Giga Sage

Try this:

PeterBodelier_1-1687776968105.png

 

 

 


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

2 REPLIES 2

Peter Bodelier
Giga Sage

Try this:

PeterBodelier_1-1687776968105.png

 

 

 


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

B Ashok
Tera Guru

Yes, It worked for me when I use OR instead AND. 

 

Thank you @Peter Bodelier