Incorrect date while saving csv format

Vivek - Nov 10, 2018 at 02:14 PM
 Blocked Profile - Nov 12, 2018 at 04:58 PM

I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens it, the date gets changed. 1 Dec'18 to 31 Dec'18 is alright but 1 Jan'19 to 31 Jan'19 gets converted to 1 Jan'18 to 31 Jan'18. It automatically changes the year from 2019 to 2018. I have tried changing the system dates from control panel but it does not help. Any suggestions to correct this problem.


1 response

Blocked Profile
Nov 12, 2018 at 04:58 PM
A csv file, has no formatting. When you open it back up, don't open it from folder, but open EXCEL first, and then IMPORT the data, manually selecting a DATE for the date column!