[AccessD] Date-scoping

Because I deal with Oracle every day I have gotten into the habit of using the day before and day after. I stopped using between even on an Access DB because there were times I might miss a record.  This other way better guarantees I get all my records.
 
(TransactionTypeID= 2 
AND (TransactionDate > #02-Jul-2007# 
AND TransactionDate < #04-Jul-2007#))


*************************************************************
* Patricia E. O'Connor
* Associate Computer Programmer/Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (W) mailto:aa1160 at otda.state.ny.us
***********************************************************


--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


________________________________


From: accessd-bounces at databaseadvisors.com on behalf of Mark A Matte
Sent: Wed 08/29/2007 2:09 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Date-scoping



Not entirely...if the field is just a date and not a datetime...then BETWEEN
1/1/07 and 1/1/07 would return any records that are 1/1/07 because BETWEEN
is inclusive.  If it were a datetime...then it would only look for 1/1/07
00:00:00.

Mark A. Matte