Help, Date Not working on insert

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
 
A

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top