Incorrect date appearing in output file from Integration Center, however the date is correctly appearing in Preview. For Example: Employee termination date is "31/12/2017" but in the exported file it is showing as "31/12/2018".
Standard date format not updated in Integration Center
1. Click on the field (the field for which you are getting incorrect date format).
2. Right click on the field and click on more field options - > Field options - Maintain the standard date format as : MMM-dd-yyyy HH:mm:ss.
Click on 'More Field Options'
You can see the highlighted standard date format.
3. Now run the integration and test to see the correct results.
- Integration Center
- Standard date format in Integration Center
- Incorrect date in output file
- Wrong date appearing in exported file from Integration Center
- Output file and preview date difference
|More field options.PNG|