I had a problem like that and I believe what I ended up doing was using
dateformat on the form submitted date like
TodayDate='#DateFormat(formdate,"mm/dd/yy")#'
-----Original Message-----
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 10:39 AM
To: CF-Talk
Subject: Query in between dates
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
