Search code examples
if-statementobieecase-statement

OBIEE Case Statement

I'm trying to use a Case formula to evaluate a date but it's erroring out every time. Not sure where I'm going wrong.

1/1/9999 is a date.

Code:

CASE WHEN "Item "."Store OOS" = 1/1/9999 THEN 'repln' ELSE 'Fashion' END

Solution

  • CASE WHEN "Item"."Store OOS" = date '9999-01-01' then 'repln' ELSE 'Fashion' END