sql and access

[Darrenw]

When I am returning records using ado and sql based on dates sometimes I can use "dd/mm/yy" however sometimes I must use "mm/dd/yy" my queries are on the same date field in access
can anyone explain why this is happenung???