sysdate object

building reports webintelligence
1

I have a situation where 3 date objects in my query need to be filtered as less than sysdate. Is this possible in the query or do I have to do this on the report??

shalini (BOB member since 2008-03-26)

2

Hi,

Create a predefined condition in the universe. The condition should look similar to this:

table.date_column <= sysdate

Then use the condition in the report query.

Marek Chladny :slovakia: (BOB member since 2003-11-27)