Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting MON from sysdate in Discoverer Condition

533780Sep 27 2006 — edited Oct 3 2006

Hi,

I have written a condition that looks at opendate:month >= TO_DATE(SYSDATE-1, 'MON') but when discovere executes the worksheet I get invalid Month.

If I change the calculation to opendate >= SYSDATE-1 Then this works fine but retrieves the full date and only yesterdays date. Where as I need yesterdays month! Has anybody got any ideas?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2006

Added on Sep 27 2006

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

4 comments

953 views