Entering date into Access

[neilorourker]

I'm sure this is basic level stuff but I've been away for a year so please bear
with me.

Basically I want a date entered into a form inserted into Access. I have tried
the following

Format inputed inthe form: '25/05/2005'

Line in update query:
setupdate = '#CreateODBCDate(form.setupdate)#',

Cheers

Neil

[SilverStrike]

basically, the way I work with dates is using three select boxes (for year,
month and day).
and then, to insert the data into the DB I use the following:

date = #CreateODBCDate(CreateDate(FORM.year, FORM.month, FORM.day))#

Where FORM.year, FORM.month and FORM.day are the names of the select boxes.
The problem with your example is, that you can't know how the user inputed the
data into the field.

[mxstu]

Also, you do not need to use single quotes around the CreateODBCDate() function.

HTH

[neilorourker]

cheers

I tried that recieved the following error when running the update query:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression ''{d '2005-05-25'}''.


SQL = "UPDATE tbl_artists SET setupdate = '{d '2005-05-25'}' WHERE
tbl_artists.artistid=118"

the form variables were set as follows:
<cfset setupdate= #CreateODBCDate(CreateDate(FORM.setupyear, FORM.setupmonth,
FORM.setupday))#>

[SilverStrike]

Please include in the insert query.
It seems you use single quotes. it seems this is the problam.

[neilorourker]

cheers

That's sorted the problem