Best way to create a condition <obj name> = sysdate

building reports desktopintelligence
1

Hi,

In BO Full Client reporting tool v6.1b,

I would like to know the best way to create a condition like = current date (or sysdate) where is a date object.

Thanks
Gana.

gana (BOB member since 2004-04-14)

2

The “best way” is with a universe object. Two choices there:[list]1. Create an object with trunc(SYSDATE) as the Select. It may not parse, but should work just fine in a query. In the query panel, put your date object as a condition, and set it equal to the SYSDATE object.
2. Create a pre-defined condition with a Select of table.datefield = trunc(SYSDATE). Now just use this object as a condition in the query panel.[/list]

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

3

Thank you!! :smiley:

…and apology for a late reply. :?
:?
Gana.

gana (BOB member since 2004-04-14)