try using this:
<cfquery name="getdate" datasource="suppkb" dbtype="ODBC">
SELECT *
FROM Main_Table
WHERE convert(char(10),Date_Entered,101) BETWEEN
#dateformat(date,"dd/mm/yyyy")# and #today#
</cfquery>
that will ensure Date_Entered is also in "dd/mm/yyyy" format.
works for me... let me know!
Thanks,
Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
