try this:
<cfset firstdate=dateadd('d',-90,now())>
then, in your query......
where facility = 'Atlanta' and rcvd_date < #firstdate# and audit_date = NULL
HTH
D
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 11:09 PM
To: CF-Talk
Subject: searching date ranges
I have a database with fields called facility,
rcvd_date and audit_date. I need to query the database
for a user selected facility with a rcvd_date that is
greater than 90 days old and the audit_date field is
blank.
For instance, the user selects Atlanta, and the query
will return all records for Atlanta, where the
rcvd_date is older than 90 days from the current date,
and the audit_date field is blank. So, if a record
for Atlanta has a rcvd_date of 05/01/2001, it would
not be returned, but one with a date of 02/01/2001
would.
I have the facility portion done, but can not figure
out how to search the rcvd_date field to check the
records with dates 90 days old or more. Any ideas?
Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
