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

Date Format Question

P: n/a
Hi, I need to enter date into a control without a month day - just mm/yyyy.
I tried to use format mm/yyyy. It displays date OK, but when I edit, it
shows dd/mm/yyyy.
What's the corret way o doing that?

Thank in advance,
AK

Mar 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Internally, the date/time field is stored as a floating point number, where
the integer represents the date and the fractional part is the time of day.
It is therefore impossible to store a date without the day. Setting its
Format only affects how it is displayed, not how it is stored.

If you really want to store month and year, use 2 number fields:
TheMonth Number Integer Validation rule: Between 1 and 12
TheYear Number Integer Validation rule: Between 1900 and 2999

Alternatively, you could use the first of the month to represent the date in
the month.

Or, if this is for something like credit card expiry, you need to use the
last day of the month (which is when the card actually expires.)

Since your example used d/m/y format, you might also like to read:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Anatoly Kurilin" <ak******@nordsoft.ru> wrote in message
news:e0**********@alpha2.radio-msu.net...
Hi, I need to enter date into a control without a month day - just
mm/yyyy.
I tried to use format mm/yyyy. It displays date OK, but when I edit, it
shows dd/mm/yyyy.
What's the corret way o doing that?

Thank in advance,
AK

Mar 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.