Access and Querying using Dates - TechRepublic
General discussion
January 13, 2002 at 06:47 PM
desmondm

Access and Querying using Dates

by desmondm . Updated 24 years, 4 months ago

Can anyone tell me why access changes the date format when u are querying.

if u enter a date 10/01/2001 (dd/mm/yyyy) in the creteria, the date will be changed to 01/10/2001 (mm/dd/yyyy). Is there a way of preventing this from happening as this isannoying and gives wrong results depending on the person entering the parameters.

regards

This discussion is locked

All Comments