Date syntax

[callhandler]

What are the idiosyncracies of the date format in Access?

why does the following fail?

INSERT INTO records(date) VALUES (#02/28/1972#)

The field "date" not surprisingly, is a date field.

 

[mikey69]

Once again, i'd do this using the query grid. but if you really want to use SQL I think the syntax for the field name is:

[recordname].[Fieldname]

 

[wanttoscript]

Unfortunately, I can successfully execute something like:

INSERT INTO records(number) VALUES (10)

where number is a field of type integer.

But, when I try a date format it fails?!?!
I must be doing somthing wrong, but I don't know what.

 

[jebry]

Hi!

What error to you get? The first thing you ought to do is rename the field. Never use a reserved word as the name of a field, control etc. Try using fldDate.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[wanttoscript]

Problem solved ... thank you for your insight