G'day All,
I am having great difficulty getting dates to save in an access database in the format I require. Regional settings set to "dd/mm/yyyy".

The problem is with days 12 and less where access seems to have a mind of its own. Sometimes it will save correctly others it will reverse the positions of the dd/mm to mm/dd.

Help Please
Gaza