According to Microsoft, all its products can cope with the new century, but they do so in different ways. The Access 95 database interprets a year entered as ΓÇÿ10ΓÇÖ as if it were ΓÇÿ1910ΓÇÖ but you can force the date to 2010 simply by typing it in as four digits.
Access 97 and Excel 97 already interpret two-digit dates between ΓÇÿ00ΓÇÖ and ΓÇÿ29ΓÇÖ as ΓÇÿ2000ΓÇÖ to ΓÇÿ2029ΓÇÖ, but the previous three versions of Excel only do this with dates between ΓÇÿ00ΓÇÖ and ΓÇÿ19ΓÇÖ. If you type ΓÇÿ20ΓÇÖ into one of these it is stored as ΓÇÿ1920ΓÇÖ.
With Microsoft products, you can get round such inconsistencies by developing the habit of typing four-digit years, but if youΓÇÖre examining other software for year 2000 readiness, look for situations where you want to specify a year 2000 date but can only type in two digits. In this situation, are you sure you know how the date is being interpreted?
