Symptom
The date format of the generic date ield is causing an issue when triggering a rule that directly compares the date value against another date value.
Environment
-
Employee Central
- Rules Engine
Reproducing the Issue
1. Create a rule that compares a date value against another date value.
2. Create rule trace.
3. In the log you will notice that the comparison of the generic date field has a date format issue as pictured below.
4. This highlights that the same date FEB 02 2018 is Compared against 2018-02-02 and the result is NOT EQUAL is True.
Cause
-
This is a date Format issue within the rules engine and Engineering are aware of this.
Resolution
-
Engineering have confirmed that this will be fixed in the 1805 release.
There is a workaround for this, instead of comparing the date values directly, use the function Get number of calendar days() on both sides of the IF statement.
See Also
ECT-91862
Keywords
Date Format, Issue,Rule, Date value,Get number of calendar days(),Comparing Date Value,Rule Trace,Log, Rules Engine,Directly Compare Date Value, Generic Date,Triggering a Rule, 1805,IF Statement,ECT-91862 , KBA , LOD-SF-EC-TIM-RUL , TAT Rules, Validation & Take rules , Problem