validation text for an expiry date on a credit card

[sparky2005]

Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:

MM/YY but i cant find a way of doing this!

I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:

>=int(now())

So the input mask has to accept this validation...

If you could help, i would be very greatful!

Cheers

 

[whitespace]

I assume your at the table design stage.

You could just use put the following in input mask..

"01"/99/99;0;

and then >=now() in validation rule... This will mean that you will only need to input 09/06 for example to store September 2006... This obviously assuems the 1st day of the month is selected. Because of the way dates work you have to specify a full date even if you are only interested in the month and year...

The dates will still be stored as a proper date though (with the days) - maybe you can hide them in a form later?