Checking for Expiration with Month and Year

Discussion created by MattLeach on Feb 3, 2012
Latest reply on Feb 3, 2012 by RayCologon

We've integrated credit card processing into our FileMaker solution using X-Chare's filemaker plugin and everything has been going well.


Our solution stores a clients credit card information such as type, mmasked acct # and expiration. When i mean store, the card is actually not stored in our solution. It is stored on X-Charges secured server and assigned an alias which is entered into filemaker.


What i'm looking to do is build in some error checking in regards to the expiration of the credit card. Normally this would be a no brainer but since the expiration contains only the month and the year, not an actual date, i'm not quite sure how to go about this.


Basically im needing to check the month and year of the current date again the month and year of the card expiration date to see if the card is expired or not.


The expiration date is stored in a field called CC_Exp and is in the format of MM/YY.


I'm assuming that i would need to parse the field as assign a variable for month and year?


ANy help is appreciated. Thanks