There was one-day error when exporting date from DG to an excel sheet

[petercreateParticipant]

date
2020-03-01
2020-03-02
2020-03-03
2020-03-04
2020-03-05
2020-03-06
2020-03-07
2020-03-08
2020-03-09
2020-03-10
2020-03-11
2020-03-12
2020-03-13
2020-03-14
2020-03-15
2020-03-16
2020-03-17
2020-03-18
2020-03-19
2020-03-20
2020-03-21
2020-03-22
2020-03-23
2020-03-24
2020-03-25
2020-03-26
2020-03-27
2020-03-28
2020-03-29
2020-03-30
2020-03-31
2020-04-01
2020-04-02
2020-04-03
2020-04-04
2020-04-05
2020-04-06
2020-04-07
2020-04-08
2020-04-09
2020-04-10
2020-04-11
2020-04-12
2020-04-13
2020-04-14
2020-04-15
2020-04-16
2020-04-17
2020-04-18
2020-04-19
2020-04-20
2020-04-21
2020-04-22
2020-04-23
2020-04-24
2020-04-25
2020-04-26
2020-04-27
2020-04-28
2020-04-29
2020-04-30
2020-05-01
2020-05-02
2020-05-03
2020-05-04
2020-05-05
2020-05-06
2020-05-07
2020-05-08
2020-05-09
2020-05-10
2020-05-11
2020-05-12
2020-05-13
2020-05-14
2020-05-15
2020-05-16
2020-05-17
2020-05-18
2020-05-19
2020-05-20
2020-05-21
2020-05-22
2020-05-23
2020-05-24
2020-05-25
2020-05-26
2020-05-27
2020-05-28
2020-05-29
2020-05-30
2020-05-31
2020-06-01
2020-06-02
2020-06-03
2020-06-04
2020-06-05
2020-06-06
2020-06-07
2020-06-08
2020-06-09
2020-06-10
2020-06-11
2020-06-12
2020-06-13
2020-06-14
2020-06-15
2020-06-16
2020-06-17
2020-06-18
2020-06-19
2020-06-20
2020-06-21
2020-06-22
2020-06-23
2020-06-24
2020-06-25
2020-06-26
2020-06-27
2020-06-28
2020-06-29
2020-06-30
2020-07-01
2020-07-02
2020-07-03
2020-07-04
2020-07-05
2020-07-06
2020-07-07
2020-07-08
2020-07-09
2020-07-10
2020-07-11
2020-07-12
2020-07-13
2020-07-14
2020-07-15
2020-07-16
2020-07-17
2020-07-18
2020-07-19
2020-07-20
2020-07-21
2020-07-22
2020-07-23
2020-07-24
2020-07-25
2020-07-26
2020-07-27
2020-07-28
2020-07-29
2020-07-30
2020-07-31
2020-08-01
2020-08-02
2020-08-03
2020-08-04
2020-08-05
2020-08-06
2020-08-07
2020-08-08
2020-08-09
2020-08-10
2020-08-11
2020-08-12
2020-08-13
2020-08-14
2020-08-15
2020-08-16
2020-08-17
2020-08-18
2020-08-19
2020-08-20
2020-08-21
2020-08-22
2020-08-23
2020-08-24
2020-08-25
2020-08-26
2020-08-27
2020-08-28
2020-08-29
2020-08-30
2020-08-31

 

Saying this column, when I exported them to a sheet, the date in the sheet shows from 2020-02-29 to 2020-08-30.

[dgteamModerator]

We are not able to replicate this problem.  We tried copy and pasting into a sheet and exported from DataGraph into an xlsx file and then opened in Excel and it is the proper dates.

One known issue for Excel is that the Excel files on Mac and PC save dates differently, by one day.  By any chance are you opening the file on a PC?  Also, are you opening it with Excel or some other program?

 

 

[Jean-Yves Le StangParticipant]

dgteam comment is verified using MacOS 10.14.6 +DataGraph 5.0 + Excel 16.54 with dates generated by DG as shown in the screen capture below.

No PC related test available on my side. However a significant experience on exchanging Excel files between PCs and Macs never showed such issue.

[dgteamModerator]

@Jean-Yves Le Stang   Thanks for checking on your system and confirming that you have not had any issue with files between PC and Mac Excel files. Also nice demonstration of generating dates!

FYI — In general, every Excel file should contain a flag to let what ever system is using the file know whether the file was created on Mac or PC.  In DataGraph, we have a library that  writes to the Excel file format.  The Excel files we generate should have this flag and hopefully work properly regardless of the system.

[dgteamModerator]

UPDATE:  Sorry, just going through our change log and we did have some systems with an excel date issue that was fixed in the beta.

@petercreate — Do you have the same problem if you use the beta version?

Beta

 

[petercreateParticipant]

Good to know this. I happened to use a Mac-App downloaded version. Long months ago, I used the beta version which often jumped off my Mac, and so I changed to this formally released version which is more stable. Just find this bug a few days ago when I was processing some data. Could you quickly update it on the Mac Appstore?

[petercreateParticipant]

@dgteam, it’s not a big issue. I simply +1 day in excel.

[Jean-Yves Le StangParticipant]

Hi Gents,

When I last reported that it was OK, I had only tested a copy/paste from DG file to an Excel file.

After reading dgteam comment, I tested exporting the file from DG in Excel format (File/Export Data) and I found the same error as reported by Petercreate. See below.

May be I should update my Apps as they are becoming out of age.

[petercreateParticipant]

@Jean-Yves Le Stan, thanks for digging. From your previous post, I can tell you are using a Mac platform, but was the DG a beta version or a app-store version?

[Jean-Yves Le StangParticipant]

I was for sure downloaded from your Website, so I think it is a beta (I remember a period of time when two versions were available: Last release and beta, and I think that I finally download the beta, but not sure) ?

The only references I can find regarding my DG version are below. I tried to investigate the package content of my App with no success.

I will shortly download again 5.0 from your website and revert.

[Author]

Posts