How to get filter based on time

lucky6
Tera Contributor

‎04-18-2023 04:54 AM

Hi Everyone, 

How to get filter based on time? ex. Need cases created between yesterday 8pm to today 8pm.

Can anyone help me on this.

Thanks in advance..

0 Helpfuls
  • 571 Views
6 REPLIES 6

Ankit Rawat
Giga Guru

‎04-18-2023 05:13 AM

Hi @lucky6 ,

 

You can add this condition.

Screenshot 2023-04-18 174217.png

 

 

0 Helpfuls

lucky6
Tera Contributor
In response to Ankit Rawat

‎04-18-2023 05:27 AM

It's taking the current date and time but I need it as yesterday's and today's time. 

0 Helpfuls

Ankit Rawat
Giga Guru
In response to lucky6

‎04-18-2023 05:33 AM

you can change date and time

0 Helpfuls

lucky6
Tera Contributor
In response to Ankit Rawat

‎04-18-2023 05:49 AM

When I copy the query it is showing as yesterday's and today's date and time..but it should display as yesterday and today with time then it will work.

0 Helpfuls