ADO Year conversion

[chitram]

I am having an ASP page for date and other fields data entry.

I use a VB component to convert the date from String,
using VB FORMAT function (using mm/dd/yyyy format)
and create the insert query. This query is passed as a parameter
to the execute method of adodb.Connection.

When I use the ADO to execute the insert query, the year (1930) is
stored as 2030, on the SQL Server . Only dates from 1950 to 2049 are
stored in YY format. There is no way I could store the year 1930.

Before Y2K there was no problem ;-)

NOTE: VB FORMAT converts any year between 1930 to 2029 to 2 YY format.
Any yeay < 1930 and > 2029 are shown in 4 YYYY formats

SQL Server also converts any year between 1930 to 2029 to 2 YY format.
Any yeay < 1930 and > 2029 are shown in 4 YYYY formats

Did anyone of you face this problem?

Thanks in advance
Chitram