Hi,
I know I've seen this but I cannot figure out what I'm doing wrong.
I have an Access Database with a field named outageDate which is a Date/Time
field. I want to produce a report built off a query of dates between
certain dates.
what I have is :
<cfquery name="dayData" datasource="#DSN#">
SELECT *
FROM outageReport
WHERE outageDate >= #then#
AND outageDate <= #now#
</cfquery>
Which doesn't work. The dates in my Database look like: 05/10/2001, #then#
and #now# look the same. There is no error, just nothing returned even
though I have records which should return.
I'm confused!
Pete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
