Could not get expected result in the Dynamic column of compensation

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