using dates pre-1900?

[Guest]

I need to have Excel and Access recognise dates between 1800 and 1910, in
order to perform time lapse calculations and to sort entries in date order.
Is there a way to force these programmes to recognise such dates?

 

[Niek Otten]

http://j-walk.com/ss/excel/files/xdate.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Is there a simialr fix for Access that you are aware of?

 

[Myrna Larson]

Access 2000 and above don't need a fix. They support dates prior to 1/1/1900.
I don't know about earlier versions.