Hi all,
I am using front end as Access 2000 and backend as SQL Server 2000. The forms are written in VB. I have a field titled birthdate(selected the short date option), but whenever i enter the birthdate as 1924, it gets stored as 2024 in the database.
On the form it is in the format...