First problem: you need to put pound signs around "Now()".
Second problem: even if you try that, the date format might be incorrect. What kind
of field are you searching against? What kind of database is it? What is the format
of the dates in the field?
Match up the date with your search query, and you'll get the right results.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
-----Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 11:26 AM
To: [EMAIL PROTECTED]
Subject: query date problem
This query gives me all records in the database instead of just what I asked
for. What am I doing wrong?? This NewDateArc field is a DateTime field in
Access
<cfquery datasource="Articles" name="DeleteOldArc">
select * from ArchivesCopy
WHERE NewDateArc < NOW()
</cfquery>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
