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!

CASE statement using DATES

3025352Apr 26 2016 — edited Apr 29 2016

Hi all,

I need help with the following filter logic in my report.

The logic is as follows: When an Agreement Sent Date.Date is 1969 then cast it as 'NULL' or '0'.. Doesn't really matter. Else show the 'Date' field.

Here's what I currently have and it's not working.

CASE WHEN "Agreement Sent Date"."Date" = '1969-12-12' THEN CAST(NULL as TIMESTAMP) ELSE "Agreement Sent Date"."Date" END

Thank you in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2016

Added on Apr 26 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date

12 comments

4,664 views