How to add a validation rule for a credit card?

[dfean]

Hiya,

I'm trying to in access add a validation rule for the expiry date for a credit card:

I have come up with this:

Format: mm/yy
Input Mask: 99/99
Validation Rule: <=DataAdd("m", 36, Data())

I know that this validation rule: <=DateAdd("d",1095,Date())
works.



I don't want to include the day, just month and year only.

[ranman256]

You can't. It must be a a whole date so use the 1st of the expired month.