[AccessD] Date issues in Access

connie.kamrowski at agric.nsw.gov.au connie.kamrowski at agric.nsw.gov.au
Thu Sep 18 20:03:37 CDT 2003


Hi Everyone,

I am a newbie to thsi list but am at my wits end.
I have a problem with Dates in Access. It is happening in two seperate 
applications. 
I am in Australia and need to have the Date format as dd/mm/yy. 

When a date is entered into a field it is displayed correctly ie. 06/08/02 

when it is returned to me via a msgBox popup for troubleshooting it is 
displayed as 08/06/02 (US Format). 
when the date is after the 12th of the month it is all working fine. It 
only reverts to US format if the date is before the 12th.
I am in Australia and need to have the Date format as dd/mm/yy. 

Thanks 
Connie Kamrowski
Analyst/Programmer



This message is intended for the addressee named and may contain 
confidential information. If you are not the intended recipient or 
received it in error, please delete the message and notify sender. Views 
expressed are those of the individual sender and are not necessarily the 
views of their organisation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030919/db1ac4b2/attachment.html>


More information about the AccessD mailing list