Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Is it possible to use an EFF in a case statement in OTBI?
Summary:
I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error, and I believe it is coming from the EFF since I have done this calculation before using delivered date fields. Any help is appreciated, thanks!
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
CASE WHEN "Assignment Event Details"."Effective End Date" = date '4712-12-31' THEN NULL
Tagged:
0