Hi there, Would using CFQUERYPARAM in your query, and setting the SQL Type to Date help?
I've had this problem with queries before in WHERE clauses. In Oracle I would have suggested using the Oracle ToDate() function. Otherwise CreateODBCDateTime() usually takes care of these issues with inserting dates. -Gel -----Original Message----- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Here is the whole insert query, I tried it with and without the single quotes. <CFSET date = Now()> <CFQUERY DATASOURCE="#application.dsn#" NAME="new_cust_insert"> INSERT INTO customer VALUES ( '#custNum#', '#f_name#', '#l_name#', '#address_1#', '#address_2#', '#city#', '#state#', '#zip_code#', '#phone_1#', #ext_1#, '#phone_2#', #ext_2# '#dateFormat(date, "mm/dd/yyyy")#' ) </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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