Validation rule for Expiry Date for credit card in Microsoft Access

[dfean]

Hiya all,

I'm wondering how to apply a validation rule for and expiry date of a credit card.

Format: mm/yy
Input mask: 99/99


Validation rule: <=Date()+1095

this doesn't work and I don't know what the validation rule could be.

Could somebody help me please?

[alansidman]

I got this to work if you change up to as follows:
Format: mm/dd/yy
Input mask: 99/99/99
Validation rule: <=DateAdd("d",1095,Date())

Of course this means that you would have to enter the dates showing the last day of the month of expiry.

[RuralGuy]

I would suggest using the BeforeUpdate event of the control on the form. Much more flexible than using a validation rule in a table.

[dfean]

Thank this works perfectly.

[RuralGuy]

You're very welcome. Thanks for posting back with your success.

[dfean]

This also works perfectly too thanks.

I got this to work if you change up to as follows:
Format: mm/dd/yy
Input mask: 99/99/99
Validation rule: <=DateAdd("d",1095,Date())

Of course this means that you would have to enter the dates showing the last day of the month of expiry.

[alansidman]

You are welcome.