Report Studio Filter for a Defined Daily Period

[locus]

Morning Folks,

I am currently running a series of reports each morning that I would like to schedule.

The existing prompt page parameters are as follows

[start.dtim]>=?Parameter1?
[end.dtim]<=?Parameter2?

The prompt values are always as follows: 

?Parameter1?>=7am (for previous day)
?Parameter2?<=7am (for current day)

How do I write this in so when it runs at 8am each morning, I always get values between 7am (yesterday) and 7am (today)?

I currently use the following filter on a slightly different report but am having trouble modifying it
............between (trunc(_add_days({sysdate}, -1),'dd')) and (trunc({sysdate}))

Appreciate any help.

Cheers,
Locus

[chipslam]

which db you are using ?

[locus]

Informix

[RubenvdLinden]

This might help:

Yesterday: cast(_add_days(current_date; -1); timestamp) + 7 hour
Today: cast(current_date; timestamp) + 7 hour

[locus]

That's spot on. 100%

Thanks Ruben!

[RubenvdLinden]

You're welcome!