Date Format Question

[Anatoly Kurilin]

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

[Allen Browne]

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