SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP SuccessFactors HXM Suite

  • Integration Center

Reproducing the Issue

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.

Cause

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

Resolution

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.

Keywords

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

Product

SAP SuccessFactors Recruiting 2311

Attachments

Pasted image.png