system date in conditions

building reports desktopintelligence
1

Hi,
I am trying to create a condition that uses system date.
example:


Rights Start Date <= system date

But I am not able to find the right syntax for it.

What will be the operand?
can some one help?

Thank you.

surdee (BOB member since 2004-06-11)

2

Which RDBMS?

Sybase is getdate()

KSG :us: (BOB member since 2002-07-17)

3

Oracle.
Do I need to create an object in the universe?
I did that with sysdate, it did not parse but worked in the report.
Can I not avoid the object creation and use some feature in the reporter?

surdee (BOB member since 2004-06-11)

4

Your best bet is to create an object in the universe. And it will not parse. See this topic in Designer.

Anita Craig :us: (BOB member since 2002-06-17)

5

There is a current date function in Reporter and you can build a variable based on this but that will not do you any good if you are trying to condition on the actual query, thus limiting the results returned based on a sysdate.

jswoboda :us: (BOB member since 2002-06-20)

6

Thank you. :slight_smile:

surdee (BOB member since 2004-06-11)