Hi Folks,
Got a problem with the online support knowledge bas on our intranet.
Basically the date search for KB items does not seem to be getting the
correct values. I noticed that the Access DB datasource has the date in a
couple of formats, either dd/mm/yy or dd/mm/yy hh/mm/ss.
The search form lets users enter values in dd/mm/yyyy or with a 2 date
year but, nothing seems to be happening.
Heres the code:
<cfset today = #dateformat(now(),"dd/mm/yyyy")#>
<cfquery name="getdate" datasource="suppkb" dbtype="ODBC">
SELECT *
FROM Main_Table
WHERE Date_Entered BETWEEN #dateformat(date,"dd/mm/yyyy")# and #today#
</cfquery>
<cfoutput query="getdate">#date_entered#, #Record_id#<br></cfoutput>
<cfabort>
Can any eagle eyed code spot my flaw ?
Cheers,
Darren Adams
Web Developer
Marketing Department
Systems Union
Office: 01252 55 6220
Mobile: 07714 817 038
Email: [EMAIL PROTECTED]
"Data + Structure = INFORMATION"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
