Re: 1904 date system in spreadsheets
I have just spent two days correcting the dates on records imported from spreadsheets that had the 1904 date system set. They were all copies of our standard excel spreadsheet that uses the windows standard 1900 date system but had been used on a Mac, and when saved the Mac unhelpfully changed the date system to its default of 1904. The dates still showed correctly in the spreadsheets when I got them but were imported to R6 as four years and a day earlier.
As more people seem to be using Macs and we can't rely on me noticing or them always remembering to override the default, could a future release of R6 check the date system used before importing the spreadsheet and adjust if necessary?
I really don't want to go through this again!
Janet
British Lichen Society