Time/Date Filter for reports

Nats.Rudy

I have a report where I want to filter all items that occurred in the past 24 hours from the moment in time of 06:00am today. Can someone help to guide me in how I would set up the filters in the report?

Marlana K.

@Nats.Rudy Are you building a report just to track changes in a sheet?

Why not use Highlight Changes (it is available in both sheet or reports). It is the icon that looks like a highlighter in the tool bar.

Nats.Rudy

Hi Marlana,

No the report should extract all entries made from 06:00 the previous day to 05:59 the current day from the main sheet where incidents are reported.

Marlana K.

@Nats.Rudy Thanks then I would recommend using Date and Time entry fields when entries are made, if you are not already doing so. Then you could set the filters base off of those:

Where Date is between and Time is between