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
Case Statement error on Task Completion Date
Summary:
Hello, I need help to check if this case statement is correct. My case is if the "Step Completion Status" is 'Completed', it returns the "Step Completion Date"; otherwise, it returns an empty string. Thank you in advance!
CASE WHEN "Workforce Performance - Performance Task Status Real Time"."- Performance Task Status Details"."Performance Task Status" = 'Completed' THEN "Workforce Performance - Performance Task Status Real Time"."- Performance Task Status Details"."Step Completion Date" ELSE '' END
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):
Tagged:
0