3425025 - The integration Center calculation field should display the output value as 9999-12-31T00:00:00Z instead of 10000-01-01T00:00:00Z

The integration Center calculation field should display the output value as 9999-12-31T00:00:00Z instead of 10000-01-01T00:00:00Z

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

• Integration Center

1. Add Calculation Field with DateTime Type, the trace is below:

If/Then/Else [End Date (endDate) from Background_Education] is greater than or equal to 12/31/9999 
  Field Value = [End Date (endDate) from Background_Education] 
Else
  Field Value = [End Date (endDate) from Background_Education] + 1  'D'  

 Results:

1. 9999-12-31T00:00:00Z is displayed on the Preview page.
2. 10000-01-01T00:00:00Z is displayed on the export CSV file.

There are limitations in the integration center's calculation column when comparing the custom date format. e.g. 12/31/9999

On the Calculation field page, we have encountered a warning message: "We recommend that you do not provide any format for the date selected either from the default values or from the association. This will lead to inconsistencies during the execution of the integration."

Therefore, if you need to compare date-type fields, we recommend using two date-type fields for the comparison instead of manually inputting a date value.

Compare, Calculation Field, DateTime, Field Date Time, Integration Center, output, Incorrect Date , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem