- Read CSV file to Excel
- Add Date column in Excel
- Write back to CSV (Needs to be a csv, this flows in to another program)
When viewing the CSV, the date format changed to “mm/dd/yyyy” from the default excel format “yyyy/mm/dd”. Also, CSV field format is “General” not a “Date” format.
I read the forums for a solution, but nothing that really deals with this situation.
Thanks in advance