Date Problems

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

In SQL Server Enterprise Manager get the properties page for the server, click on"Server Settings" and adjust the "Two-digit year support" to your needs. This a SERVERWIDE setting. By default it is set to interpret two digits as years from 1950 to 2049.

It may be better to ask for a change of the date format to "mm/dd/yyyy".