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

Date Format/Input Mask

P: n/a
I need my Date field to possess the following format: Jan-05-1999

How do I change the Date Format/Input Mask to accomplish this?

Thanks!

John

Jan 30 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jmarr02s wrote:
I need my Date field to possess the following format: Jan-05-1999

How do I change the Date Format/Input Mask to accomplish this?

Thanks!

John
With the understanding that dates are always stored in the tables exactly
the same regardless of format or input mask...

Use a format property of "mmm-dd-yyyy"

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jan 30 '07 #2

P: n/a
On Tue, 30 Jan 2007 15:26:11 -0600, "Rick Brandt" <ri*********@hotmail.com>
wrote:
>jmarr02s wrote:
>I need my Date field to possess the following format: Jan-05-1999

How do I change the Date Format/Input Mask to accomplish this?

Thanks!

John

With the understanding that dates are always stored in the tables exactly
the same regardless of format or input mask...

Use a format property of "mmm-dd-yyyy"
jmarr02s
The input mask is fine for the person entering the data.
How the data is actually stored in the table is really unimportant.
However, when you pull dates out of the table then format the display:
Format({date field},"Mmm-dd-yyyy")

Chuck
Jan 31 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.