I am using an sql to select records from an Access file and need to know what format the database expects dates in - it seems to be mm/dd/yy is there any way i can change this to dd/mm/yy?? Because this is how it is entered via the DTPicker. Thanks