Help, Date Not working on insert

  • Thread starter Thread starter Richard Albrecht
  • Start date Start date
R

Richard Albrecht

Hi,

I'm running the query:

Insert into tblPersonCEUs03Tech( PersonID, EventNumber, SeiminarNumber,
CertSent ) Values (65101, "1-2003","03TS11-200",10/13/03)

The problem is the date in the table is: 12/30/99

The field is a Date/Time. What am I doing wrong?

TIA

Richard Albrecht
 
Use # as the delimiter around your date value:
.... Values (65101, "1-2003", "03TS11-200", #10/13/2003#)
 
Back
Top