Need help with CASE formula
Summary:
I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is <= 10/1/2023, then show as 10/1/2023, otherwise show actual hire date.
CASE WHEN "Worker"."Employee Hire Date" <= 10/01/2023 then '10/01/2023' else "Worker"."Employee Hire Date" END
The formula itself does not return an error, but when I run the report, this error is returned:
State: HY000. Code: 22024. [nQSError: 22024] A comparison is being carried out between non-compatible types DATE and INTEGER. (HY000)
What am I missing? Any suggestions would be appreciated.
Content (required):
Version (include the version you are using, if applicable):