Stuart McLachlan
stuart at lexacorp.com.pg
Thu Sep 18 20:42:35 CDT 2003
Use Format$(mydate,"dd/mm/yy") in your messagebox. On 19 Sep 2003 at 11:03, connie.kamrowski at agric.nsw.go wrote: > 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. -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg