Create table with date format not working.

krstofer · March 15th, 2004, 09:17 AM

Hi, I am trying to create a new transcript table. I want two of the fields to be date formats. When I try this code:

Code:

DIM strSQL
    strSQL = "CREATE TABLE transcript(" &_
             "id integer Primary Key, " &_
             "course varchar(50) NOT NULL," &_
             "crs_date date NOT NULL," &_
             "reg_date date NOT NULL," &_
             ");"

I get this error:

Column_or_parameter_#3:_Cannot_find_data_type_date

Can anyone help? The DB is SQL Server 2000

Thanks in Advance!
Krs

pgtips · March 15th, 2004, 10:39 AM

For SQL 200 its "datetime" not "date".

krstofer · March 15th, 2004, 10:45 AM

Quote:

quote:Originally posted by pgtips
For SQL 200 its "datetime" not "date".

Awesome!!

I have been looking for the answer to this for over a week.

Much Thanks!!

Krs