Incorrect date while saving csv format

- - Latest reply: ac3mark
Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
- Nov 12, 2018 at 04:58 PM
Hello,

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.


See more 

Your reply

1 reply

Posts
10909
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 7, 2018
0
Thank you
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!
Respond to ac3mark