Loading Date Values into Access

[Naveen]

I have the following SQL query:

nsert into employees values ('SCHLESINGER',
'KATHY',
8,
'ACTIVE',
866131,
'BIOLOGICAL CLINICAL DEVELOPMENT',
'SCIENTIST IV',
'X',
'0700',
'R&D',
'BIVI',
'Active',
'FT Salaried Exempt',
1977-12-19,
'0001',
'KSCHLESI',
'MO',
645051501)

Upon insertion, the ‘Current Hire Date’ field shows a value of ‘4/29/1905’.
In the SQL above, the value was ‘1977-12-19’.

Also the data type of the above field is ‘dateTime’ in the table.

What is going wrong here.

Thanks for any help.

Naveen
P.S - I have Microsoft Access 2002

 

[Chaim]

I believe the date value has to be enclosed between '#' symbols as in
#1977-12-19#

Good Luck!

 

[Naveen]

But of course.

Thanks very much for your help, Chaim.

Regards
Naveen