Issue Description
There might be a scenario where you are trying to load Dates into EPBCS application and you end up with dates not getting loaded, and for the dates column you get a Blank value.
But in Data load workbench it shows that the data is loaded successfully.
The Import and Export process also shows success.
Root Cause
The Format for the column which holds the Date information is not correct.
Solution
Data management supports loading date in two formats
MM-DD-YYYY & DD-MM-YYYY
Based on the date format set in your EPBCS application the date format can be selected
Most preferably MM-DD-YYYY
So while designing the source file which is a CSV file, ensure you select the entire Date column
Right Click > Format Cells > Select Custom > and in the TYPE: section enter MM-DD-YYYY or DD-MM-YYYY based on what is defined in your application.
Note:
Ensure the value entered in the Type section should be in CAPS, Data management will not throw an error if you use Lower case, but the Date information wont get loaded to the EPBCS application.
