Entering Dates in mm/yyyy Format

[jaydwest]

I would like to use a date field in the format mm/yyyy, but want to allow users to enter it in the format mm/yy. I set

Format: mm/yyyy
Input Mask: 99/99;0

When I enter 02/99 it returns 02/1999
but when I enter 02/01 it returns 02/03

Upon further research Access thinks the 01 is the DOM and returns the current Year. This trick works thru the last date of the month entered.

Neat! Microsoft strikes again.

Short of using a text field for entry and converting it to a date, is there any way around this.

By the way, it works perfectly if you change the input mask to 99/9999;0 but who wants to enter four digits.

Thanks in advance for your help!

 

[jaydwest]

Pat,

That's all well and good. But I'm not sure that Microsoft is that rational. If they had intended using the second number as DOM, why does it accept 99 and convert it to 1999?

Using the same entry for two different values is at best confusing, and at worst poor design.

Jay