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

Date problem

P: n/a
How come when i type in date : 30/12/03 it will change to 12/03/3 ? i
use short date type and input mask 00/00/00;0;_ . Pls help. Thanks.

Regards,
Daniel
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Daniel Tan" <da*******@time.net.my> wrote in message
news:6a**************************@posting.google.c om...
How come when i type in date : 30/12/03 it will change to 12/03/3 ? i
use short date type and input mask 00/00/00;0;_ . Pls help. Thanks.


Any time you used the *named* formats (Short, Long, General, Currency, etc.),
the result is determined by the Windows regional settings in Control Panel. If
you want a format that does not depend on these settings then use an explicit
format string like "dd/mm/yy".
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
Rick, in the table design view, i put dd/mm/yy in the date field's
format ?

Regards,
Daniel


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
"Daniel Tan" <da*******@time.net.my> wrote in message
news:3f*********************@news.frii.net...
Rick, in the table design view, i put dd/mm/yy in the date field's
format ?


That would work if you were entering/viewing data directly in the table.
If you want the format on your form then you need to put the property in
that control as well.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.