Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Data Selection on Null Date or Time

edited May 15, 2014 10:05AM in Design Tools & Output Technologies - JDE1 (MOSC) 15 commentsAnswered

I've created a new report and I want to set data selection where a date field is Null.  I've run a SQL query to view the data prior to running the report and I'm getting over 2000 rows where the date is null.  When I ran the report, it only returned 2 rows.  The only item in my data selection is the date parameter.  The data dictionary data type is Date.  If I look at the data in data browser I can the rows where the date appears to be null.

I have a time field that I also tried to use.  I set the data selection where the time is equal to null or zero.  Again, I only got the 2 lines instead of 2000+.

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