Searching in a date range with sql
-
hey, I have a ms access file that stores when an entry was made. if that date field is today, i want to store it in a recordset object. how do i query that? "SELECT CheckDate WHERE Checkdate = ???? TO ???? " how would that work??? Please help! Thanks a bunch! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com
-
hey, I have a ms access file that stores when an entry was made. if that date field is today, i want to store it in a recordset object. how do i query that? "SELECT CheckDate WHERE Checkdate = ???? TO ???? " how would that work??? Please help! Thanks a bunch! ~Timothy T. Rymer http://tim.xpertz.com http://www.digipen.edu http://www.ttrx.com
SELECT CheckDate WHERE CheckDate BETWEEN #??/??/??# AND #??/??/??# should do it.
-
SELECT CheckDate WHERE CheckDate BETWEEN #??/??/??# AND #??/??/??# should do it.
Ed Gadziemski wrote: SELECT CheckDate WHERE CheckDate BETWEEN #??/??/??# AND #??/??/??# should do it. Thanks! I live and learn. Being doing it the hard way all this time :rolleyes: FEI: for SQL users replace the hash/pound, #, with a single quote, '. e.g.
SELECT CheckDate WHERE CheckDate BETWEEN '??/??/??' AND '??/??/??'regards, Paul Watson Bluegrass Cape Town, South Africa The greatest thing you'll ever learn is just to love, and to be loved in return - Moulin Rouge Tim Smith wrote: Over here in the third world of humor (a.k.a. BBC America), peterchen wrote: We should petition microsoft to a "target=_Paul" attribute.