Date Format Problems

Originally posted by : David (davo__@hotmail.com)I have been having various problems with formating dates to the australian format (dd/mm/yyyy). I am using ACCESS, the query I am sending to the database is:UPDATE tailback SET tailback_status='In Progress', tailback_processdate=#01/10/2001#, tailback_processtime=#15:23:13#, tailback_processps='dr' WHERE tailback_refnumber=12313 In the field tailback_processdate (in table "tailback") I have set the custom format to dd/mm/yyyy.However in the database the field tailback_processdate is displayed as 10/01/2001.Why is this?! The custom format should overide any regional settings, shouldn't it?!

Originally posted by : Mark (markr@tio.nl)------------David at 10/1/2001 11:02:54 PMI have been having various problems with formating dates to the australian format (dd/mm/yyyy). I am using ACCESS, the query I am sending to the database is:UPDATE tailback SET tailback_status='In Progress', tailback_processdate=#01/10/2001#, tailback_processtime=#15:23:13#, tailback_processps='dr' WHERE tailback_refnumber=12313 In the field tailback_processdate (in table "tailback") I have set the custom format to dd/mm/yyyy.However in the database the field tailback_processdate is displayed as 10/01/2001.Why is this?! The custom format should overide any regional settings, shouldn't it?!You should try to use a format on the date. Access always US format for the date on the background (i.e. when calculating or comparing dates). So when you want to do something with a date use a US format. If you want to show a date use the format of your choice. for exampleformat(tailback_processdate=#01/10/2001#,dd,mm,yyyy)