change #dateformat(now(),"MM/DD/YYYY")# to #CreateODBCDate(Now())# for just date with 12:00AM for time
OR to #CreateODBCDateTime(Now())# to get current date and time HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Brian Fox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 10:32 AM Subject: MS Access - Updating a date value broke > Hi - > > Here's a query that is run against a Microsoft Access database. It has been > working fine for a few years now, but has suddenly broke. Starting this > month, Access is recording the DATE_SUBMITTED as a time value, usually > around 12:00 AM, instead of a date. The last recorded correct date is > 1/8/2002. > > Anyone know what would cause this? > > <cfquery name="ClassSubmit" datasource="facultygrade"> > update courses > set WEB_STATUS=2,DATE_SUBMITTED=#dateformat(now(),"MM/DD/YYYY")# > Where CRN='#attributes.crn#' and > (INSTRUCTOR_ID_1='#User#' or INSTRUCTOR_ID_2='#User#' or > INSTRUCTOR_ID_3='#User#') > </cfquery> > > Thanks, > Brian > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists