You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!