Thanks everyone. I solved it with your help!!
>From: Brad Tumy <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: query date problem
>Date: Wed, 29 Mar 2000 15:12:45 -0500
>
>Did you check the data in newDatearc? ...maybe it is less than now in all
>of the records?
>
>--
>Director, Information & Technology
>Regulatory Affairs Professionals Society
>301.770.2920 x241
>http://www.raps.org
>
>
>-----Original Message-----
>From: S R [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 29, 2000 3:03 PM
>To: [EMAIL PROTECTED]
>Subject: RE: query date problem
>
>
>Its a Date/Time field in MS Access. The field has 'Short Format' specified.
>I did place pound signs around 'NOW()' but it still does the same thing
>
> >From: "Mark Warrick" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: <[EMAIL PROTECTED]>
> >Subject: RE: query date problem
> >Date: Wed, 29 Mar 2000 11:35:33 -0800
> >
> >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?sidebar=lists&body=lists/cf_talk
>or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
>______________________________________________________
>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?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
______________________________________________________
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.
