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
FDI format date field to MON-YY
Hello,
In FDI I'm trying to format payroll action effective date as a period format 'MON-yy'. TO_CHAR is not a recognized function, I tried a CASE statement for WHEN Payroll Action Effective Date LIKE 1-% THEN 'Jan' ||'-'|| WHEN Payroll Action Effective Date 'LIKE %-2024' THEN '24' but it returns the error of:
State: HY000. Code: 22024. [nQSError: 22024] A comparison is being carried out between non-compatible types DATE and VARCHAR. (HY000)
Has anyone else encountered anything similar to this, is there a different function I can use in FDI to meet my need?
Any assistance is greatly appreciated
Tagged:
0