Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 BETWEEN IN clause in for dates

Author  Topic 

boeing747
Starting Member

4 Posts

Posted - 2001-03-21 : 05:07:48
when using Between in clause for example
SELECT * FROM table1 WHERE bday BETWEEN #03/12/1998# AND #03/20/1998#

I notice that access is not inclusive for the later argument, meaning if there was a bday on 03/12/1998 it will return but not 03/20/1998,
but I thought this Between and statement are inclusive, any idea??

   

- Advertisement -