Webi: Date in condition question 1

[cottontop]

Hi,

I'm creating a Webi query and want to use today's date as one of the conditons.

There is an date in the universe and I would like for the report to pull any date equal to less than the current date.

I tried date() but that doesn't work.

Can this be accomplished?

Thanks,

 

[Sridharan]

Its sysdate() to get the CurrentDate.

Sri

 

[Subhashab]

Hi ,
first of all is the back end an oracle database. Second have you created an object in the universe with defintion sysdate. in that case you have to choose the object while creating the condition.
in other work around you can create pre defined condition which can be used while making the report