Hi hi
i have no hair! why wont this work! The date in the db is 18/05/2001 and im using access. <cfset start_date =DateFormat(createODBCDate(15/04/1997),'dd/mm/yyyy')> <cfset end_date = DateFormat(createODBCDate(15/04/2004),'dd/mm/yyyy')> <cfquery name="testben" datasource="mydsn SELECT * FROM bentester WHERE Format(bentester.EndDate,'dd/mm/yyyy') Between #Start_Date# And #End_Date# </cfquery> <cfoutput> #bentester.enddate# </foutput> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
