Afternoon guys,
I'm a bit stuck with some dates functions I'm working with and wondered if
anyone can help. I've got a form which is used to Amend information in an
Access DB. When the user clicks the 'Amend' button the information in sent
to a query to update the appropriate field. I can get it update everything
though apart from the Departure and Return Date fields. These are set to
Date/Time in Access.
I sent a question in earlier and got this reply from Stephen Moretti:
"DateTime fields in Access need to be fed ODBC formatted date/times either
using CreateODBCDate/CreateODBCDateTime or <cfqueryparam> You don't need to
wrap odbc datetimes in quotes."
I've messed around with these ideas but no matter what I try I get an error
message coming back. Here's what I've got at the moment:
<cfquery datasource="#application.datasource#" name="update_record2">
<cfset Departure_Date = createODBCDate(#form.DepartureDateTxt#)>
<cfset Return_Date = createODBCDate(#form.ReturnDateTxt#)>
UPDATE Tour_dates
SET Tour_dates.departuredates = '#Departure_Date#'
, Tour_dates.returndates = '#Return_Date#'
, Tour_dates.fares = '#form.FaresTxt#'
WHERE (Tour_dates.Date_ID=#url.Tour_ID#) AND (Tour_dates.Tour_ID=#url.ID#)
</cfquery>
I've done a CFOUTPUT of the SET Departure_Date and it comes out as {d
'2004-11-09'}
I've also tried converting it using DateFormat first and then inserting it
but nothing is working.
Can anyone give me some pointers?
Cheers,
James
