Once Template is downloaded, check the date format.
In my scenario the date column was showing default effective date (sysdate) as '23-Feb-17'.
Uploading with the above date format was giving error.
So just use the formula in excel as =TEXT(D12, "dd-mmm-yyyy") then it was showing 23-Feb-2017
It worked fine.
Reference:
http://everydaylife.globalpost.com/keep-dates-text-excel-22095.html - section: Converting Existing Dates in Bulk
No comments:
Post a Comment