did you try the hmm what's it called createdateformat(now()) or some such
probably should look it up but you can format it with that function as well.
I still say your pulling up every record you have because your asking for
everything that was created before the exact time of your query, all syntax
problems aside, but then maybe that's what you want to do.
----- Original Message -----
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 2:02 PM
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.
