sql server odbc: Hi All, Thanks In Advance!

I am attempting to insert/update datetime records via ASP
to a SQL 2000 Server database. The data type on the field
is datetime (not smalldatetime) and the field name is not
a reserved word. I am trying to pass the value of either
now() or date() and receive the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The
conversion of a char data type to a datetime data type
resulted in an out-of-range datetime value.

I know this has probably been posted around a million

There is an easy solution to this problem. Ensure that the
time on the server is set to a 24 hour clock!