SAP Knowledge Base Article - Public

2618153 - Date Format Issue for Generic Date Fields When Triggering a Rule

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.

 

rule trace.png

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.

get number.png

 

 

 

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

Product

SAP SuccessFactors Employee Central 1611 ; SAP SuccessFactors Employee Central 1702 ; SAP SuccessFactors Employee Central 1705 ; SAP SuccessFactors Employee Central 1708 ; SAP SuccessFactors Employee Central 1711 ; SAP SuccessFactors Employee Central 1802 ; SAP SuccessFactors Employee Central 1805 ; SAP SuccessFactors HCM Core 1711