The date setting on the VB interface & database is d/m/yyyy. If the date falls on 12 Dec onwards,it saved into the Access database as d/m/yyyy (correct format). If the date fall on day 1 to 11 it is save as format m/d/yyyy. When I want to count the number of days between 9/12/2002 & 15/12/2002, it gives wrong figure due to the d/m & m/d
How come it is not able to save into database as d/m/yyyy format?
How to do it in order to save it as d/m/yyyy & retrieve the date in d/m/yyyy format?