Scenario:
User created a saved search to compare date values of two date fields. If the Date A is less than or equal to Date B, result should return "YES".
Formula Text:
case when to_char({datea},'dd/mm/yyyy') <= to_char({dateb},'dd/mm/yyyy’) then 'YES' else 'NO' end
Date A = 17/11/2021
Date B = 11/1/2022
Actual Result: YES
Expected Result: NO - since Date A is less than Date B
Solution:
Set the formula to the following: case when {datea} <= {dateb} then 'YES' else 'NO' end
Date A = 17/11/2021
Date B = 11/1/2022
Actual Result: NO