Date between Criteria

[sai_rlaf]

In design view i created a query Between [Start Date] And [End Date].

However today I noticed it doesn't seem to be inclusive.

For instance today I searched for 07/19/2011 to 07/19/2011, and should have had 150 items, however, there were 0. I then tried 07/19/2011 to 07/20/2011 and then they showed.



Is there a work around? I think the problem is the time is included with my source data but I don't know how to work around it other than always going a date greater than i want.

[boblarson]

If time is included then if you use between 07/19/2011 and 07/19/2011 then you are essentially saying:

Between 07/19/2011 12:00:00 AM And 07/19/2011 12:00:00 AM

which isn't going to give you much of anything unless something happened at exactly 12 midnight.

So when using time, you can use

Between [Start Date] And [End Date] + #11:59:59 PM#

so that it gets the entire time frame.

[sai_rlaf]

I tried that and I got the following error message.

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

Any thoughts on whats wrong?