Workaroud for Error when importing a csv file into a module with Dates in Columns
As you all might be aware that when we Export and Reimport the same CSV with dates, the timeformat changes in the export file. When you open the CSV file in Excel the dates reformat incorrectly. Below are the workaround steps to ensure the time periods are not reformatted to a date incorrectly in XLS.
Step1) Use filetype as "Excel(.xls) Excel without formatting" during exporting data out of the module.
Step 2) When you open the file in Excel the dates will be correct “MMM YY”.
Step 3) Once you update the data as needed. Save the file as CSV(Comma delimited)(*.csv)
Step 4) In the time mapping, select " Match Names"