vendredi 2 février 2018

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

Aucun commentaire:

Enregistrer un commentaire