I try to retrieve data from table using (for example) Select ... Where Date between date1 and date2 (dd/mm/yy) it returns wrong data since from Access data base mismatching dd withh mm. If i requested data from May 1 til may 10 it returns data starting from January. The format in Access data table is yy.mm.dd the select format is dd/mm/yy.