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
Attachments
Pasted image.png |