Systemdate - 3 months

building semantic layer
1

Hi all,

I want to create an object in designer as being the result of : sysdate - 3 months to compare it with another date-object. What’s the formula to create this object in the selectbox of designer ?

Thanks Nils

Listserv Archives (BOB member since 2002-06-25)

2

In Oracle? It is AddMonths(sysdate,-3).

Erich Hurst
Compaq Computer Corporation

Listserv Archives (BOB member since 2002-06-25)