Manage MM/YY date

J

John Barnes

Is it possible to control date entry to ignore the day? Have a project where
only month and year are needed, not day. Still want to sort, perform
calculations, etc. as with typical MMDDYY data entry.

How do I allow data entry to be only MM/YY? Tried changing input mask but
couldn't get it to recognize data entry withou the day.
 
J

Jeff Boyce

John

What is entered, what is stored, and what you sort by need not be the same.
If you are working with actual dates (day, month & year), you can use the
Access Date/Time data type for the field. You can decide, in one query, to
display that date as MMYY, or to sort by YYMM, without altering what date(s)
is actually stored.

I hope you're working in a form, not directly in the table. Take a look at
the Format property to get a date displayed in a form's control as MM/YY
(but keep entering as actual dates!).

Good luck

Jeff Boyce
<Access MVP>
 
Top