Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

How to constraint by time in data selection?

edited Aug 18, 2016 5:00AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center