How to constraint by time in data selection?
In the initialize event of my report, I want to do data selection based on a Date range but I only want to get all the records one hour ago from the time the report runs.
For example, let's say I run the report at 10AM. I want to get all records up to 9AM of the day the report runs. So here's my data selection in sudo code
Append User Selection<YES>
<Date Created> is equal to and greater than<Date From>
<Date Created> is equal to and less than<SL Date As Of Today>
So if Date From is 8/1/2016 and I run this report today (8/9/2016) at 10AM, then I want all records from 8/1/2016 to 8/9/2016 up to 9AM. Ignore all records from 9AM to 10AM