captvideo33065
Technical User
I'm trying to select transactions between two dates using the Criteria line of an Access Query. The format of the field is mm/dd/yyyy. When the records are selected it produces results by month disregarding year. Example: If I select transactions between 11/01/2001 and 11/31/2001, I get dates like 11/03/1999, 11/15/2000 and 11/30/2001. The field was originally built as a text field but I have since converted it to a date field.