You would use the cf function createdodbcdate (for just the date) or createodbcdatetime to include the time as well. Note: time fields in a database are real numbers so if you insert only the date then the time will be set to 12:00 midnight as well (there really is no such thing as a date field that doesn't contain a time as well).
Example: <cfquery ...> insert into mydb .... #createodbcdatetime(now())# </cfquery> HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server <<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>> http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 1:39 PM Subject: Inserting dates into access > What is the method of formatting dates prior to inserting them into accxess > so that they will remain dates instead of times > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
