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