Manage MM/YY date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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>
 
Back
Top