Business Objects Date

[Middlesbrough]

I have created a report that will compare whether a authorised date is greater or equal to today's date. I have got the user to enter today's date. How can I automate this without user having to enter the date.

e.g Authorsied_date >=Currentdate(), this has to entered in tne conditions part of the query panel of the report. All user will have to do is refresh only..

Many thanks

 

[blom0344]

Every database has a function that allows you to fetch an object that holds the current date (Now(), Today() , Sysdate, Current Date etc)
If your universe contains such an object, you can use this if you fetch at least another object.

You can use this object to evaluate it with a prompt that will hold the authorized date.

Talk to your universe designer to add the object if it is not yet defined...

Ties Blom
Information analyst