Filter for previous day and specific hour to current day specific hour

[GtrPlyr]

How would I build a filter for a column that ranges from previous day/specific hour to current day/specific hour and it is reoccurring?

I did some searching here before asking and I don't know if this would work:

[Resolved Time]between(Today - 001 08:00:00.000) and (Today 000 07:59:59.999)

Either way, I need the report to pull data from the previous day @ 8am to the current day 7:59:59.999am

 

[blom0344]

Impromptu? Cognos8? Without being more specific about the tool used this is unanswerable..

Ties Blom