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 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=listsbody=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=listsbody=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 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=listsbody=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=listsbody=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 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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.