Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Could not get expected result in the Dynamic column of compensation — Cloud Customer Connect
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

Could not get expected result in the Dynamic column of compensation

Received Response
11
Views
8
Comments

Summary:

Could not get expected result in the Dynamic column of compensation

Content (required):

Hi All,

In the user defined column of configure worksheet display task, i am trying to get the employees Hired from 12-Jul-2021 to 05-Oct-2021 and result should be default as "HV1". Expression is getting valid but when i test it by giving the date as 15-Jul-2021, it produces no results.

( [Hire Date] >= "12-Jul-2021") AND ( [Hire Date] <= "05-Oct-2021") - This is the condition i provided.

Any solution?


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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