I am experiencing a curious issue when importing data from Access 2016 (32-bit) to SPSS 24 (32-bit). The Access database contains historical dates, ranging from 1582 to 1800. Although SPSS correctly recognizes each variable that has a date-property (and therefore does not label them with a string-property), the program systematically introduces a change in the dates between the two programs. For example, the 6th of December 1729 in Access is converted in SPSS as the 30th of November 1729. The difference between the dates are the largest in 1582 (42 days) and then decreases by a day every four years until the difference is the smallest in 1753 (1 day). After 1753, the Access-dates are correctly transferred into SPSS.
Firstly, I do not know why SPSS has wrongfully labelled 1581 (and subsequently 1585, 1589, etc.) as leap years. Historically, the leap years were 1584, 1588, etc. Second, I do not understand why SPSS has introduced this issue and leaves it be until the situation corrects itself in 1753. Is there a change I can make in Access to prevent this issue? Is there a way to correct SPSS and its understanding of leap years? Is there another solution to this issue?
Thanks in advance!
Firstly, I do not know why SPSS has wrongfully labelled 1581 (and subsequently 1585, 1589, etc.) as leap years. Historically, the leap years were 1584, 1588, etc. Second, I do not understand why SPSS has introduced this issue and leaves it be until the situation corrects itself in 1753. Is there a change I can make in Access to prevent this issue? Is there a way to correct SPSS and its understanding of leap years? Is there another solution to this issue?
Thanks in advance!