G
Guest
I need a refresher on the rules of the following, independent query criteria
pieces:
I need to be sure I am getting an entire month or cutting off a month cleanly.
BETWEEN date1 AND date2 (I couldn't find BETWEEN listed anywhere in Access
and Access VBA help, but it's my understanding that it's the two dates
inclusive, but don't know how it treats the minutes and seconds)
and
I just ran a query with a search for an EndDate >#1/31/2006, and it brought
up one record dated 1/31/2006. It's a datetime Access field, formatted in
the query property to show a Short date. I'm thinking that >1/31 starts 1
sec after midnight.
The date pulled was: 1/31/2006 11:00:10 AM
Do I have to use >=2/1/2006?
Thanks.
pieces:
I need to be sure I am getting an entire month or cutting off a month cleanly.
BETWEEN date1 AND date2 (I couldn't find BETWEEN listed anywhere in Access
and Access VBA help, but it's my understanding that it's the two dates
inclusive, but don't know how it treats the minutes and seconds)
and
= date1 AND <= date2 and
<date1
and
date1
I just ran a query with a search for an EndDate >#1/31/2006, and it brought
up one record dated 1/31/2006. It's a datetime Access field, formatted in
the query property to show a Short date. I'm thinking that >1/31 starts 1
sec after midnight.
The date pulled was: 1/31/2006 11:00:10 AM
Do I have to use >=2/1/2006?
Thanks.