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
which db you are using ?
Informix
This might help:
Yesterday: cast(_add_days(current_date; -1); timestamp) + 7 hour
Today: cast(current_date; timestamp) + 7 hour
That's spot on. 100%
Thanks Ruben!
You're welcome!