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.
