Input Mask MMM-YYYY

[Guest]

I have a field on a table which has a Data Type of Date/Time, however I only
need to save the Month and Year, hence what input mask can I use to force
this please?

 

[Guest]

Hi Paul,

You cannot store just the month and year in a Date data type. You can apply
a format to a date data type so that it only displays the month and the year,
but the underlying data will include the day as well. You'd have to use a
text data type instead.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Pat Hartman\(MVP\)]

I never use input masks for dates. I find them more trouble than they're
worth. You can train your users to enter the date as feb/2006. Access will
assume the 1st as the day part of the date. Be careful though. Entering
feb/06 would result in 6 being interpreted as the day and so the date would
be feb/6/2006.

I would stick with a field defined as a date data type even if I only wanted
to enter month and year and allow the day to default to 1. The date field
will sort properly, it will be validated as you enter it, you can use it
with a crosstab, and all the date functions work with it. If you go with a
text field, you're on your own.