AnsweredAssumed Answered

Finding Date Range Issue

Question asked by ChadDoss on Apr 13, 2011
Latest reply on Apr 13, 2011 by ChadDoss


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?