RE: query date problem
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 > > > > > >select * from ArchivesCopy > >WHERE NewDateArc < NOW() > > > >__ > >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.
Re: query date problem
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 > > > > > >select * from ArchivesCopy > >WHERE NewDateArc < NOW() > > > >__ > >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.
RE: query date problem
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 > > >select * from ArchivesCopy >WHERE NewDateArc < NOW() > >__ >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.
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 > > >select * from ArchivesCopy >WHERE NewDateArc < NOW() > >__ >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.
RE: query date problem
Wrap CreateODBCDate around it: Where NewDateArc < #CreateODBCDate(Now())# However, remember that by using Now(), you're specifying everything older than the date _to the second_ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:26 PM 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 select * from ArchivesCopy WHERE NewDateArc < NOW() __ 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.
Re: query date problem
your asking for everything its got that doesn't have a date equal to greater than the exact second your run the query. Which is probably everything in the table. - Original Message - From: "S R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 29, 2000 1:25 PM 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 > > > select * from ArchivesCopy > WHERE NewDateArc < NOW() > > __ > 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.
RE: query date problem
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 select * from ArchivesCopy WHERE NewDateArc < NOW() __ 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.