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 (**/**/**), so i can enter only 24 in the year part and it is taking it as 2024. Also i noticed that when i entered 50, it got stored fine as 1950.i dont why it is doing this for only some dates.
Can anybody suggest me what the problem is and how cna i get rid of this error.
Thanks in advance.
VJ
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 (**/**/**), so i can enter only 24 in the year part and it is taking it as 2024. Also i noticed that when i entered 50, it got stored fine as 1950.i dont why it is doing this for only some dates.
Can anybody suggest me what the problem is and how cna i get rid of this error.
Thanks in advance.
VJ
