I have a date field that is set as text in the field type. Data is entered in the format 3/1/2007, etc. I'm trying to prompt the user for a date range, but keep getting wonky results. My criteria on the field is >=[Start Date] And <=[End Date]. If I select a whole month, say 3/1/2007 - 3/31/2007...