By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Date problems in Access97 developed Apps

P: n/a

Hi Everyone,

I am a newbie to this forum 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.

Thanks
--
Posted via http://dbforums.com
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
BrW
msgbox format(YourDate,"yy/mm/dd")
--> or just another format
SnowsAngel <me*********@dbforums.com> wrote in message news:<33****************@dbforums.com>...
Hi Everyone,

I am a newbie to this forum 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.

Thanks

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.