Finding Date Range Issue
I am having an issue with finding a certain date range, the problem seems to reside with 3/1/11 as part of the find. The find i am looking for is in a Date field that is entered automatically by creation date. I am entering 3/1/11...3/31/11 and when i find i get all kinds of additional records. I was able to narrow the search by trying a few things and process of elimination and found the issue to be with the 3/1/11 date. If i do a search by 3/2/11...3/31/11 everything pulls just fine. At this point I am unsure as to what is causing the issue with the March 1st dates. I have double checked that the field is a date field and the formatting is set the same across the board.
Does anyone have any suggestions as to why one date is throughing this all off?