How to avoid discrepancy when copy date?

[Bill.liu]

Iwhen I copy the date from one file to another ,the date changed.
For exampleriginal date is "May 24,2006" but it changed into "May 23,2002"
when I copy them from one file to another.And it always change the year from
other into 2002.

 

[David Biddulph]

Iwhen I copy the date from one file to another ,the date changed.
For exampleriginal date is "May 24,2006" but it changed into "May
23,2002"
when I copy them from one file to another.And it always change the year
from
other into 2002.

Look at Tools/ Options/ Calculation: 1904 date system. I presume that one
file has this set and the other unset.