Brian Dunning's FileMaker Custom Functions

CC_Expired ( ExpirationDate ; Checkdate )

Checks if credit card expiration date has past.

  Average rating: 4.5 (34 votes) Log in to vote

Kevin Bache   Kevin Bache
None
www.none.com

Share on Facebook Share on Twitter

  Sample input:
CC_Expired ( "03/2001" ; Get ( CurrentDate ) )

CC_Expired ( "3/02" ; "1/1/03" )

CC_Expired ( "3/6" ; "1/1/2003" )

CC_Expired (0306 ; "1/1/2003" )

CC_Expired (032006 ; "1/1/2003" )
  Sample output:
1

1

0

0

0

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

-------------------------------
CC_Expired version 1.3.1
-------------------------------
Returns 1 if the credit card will have expired by CheckDate, 0 if not.

Credit card hasn't expired until after the CheckDate month is later than the ExpirationDate month (so in December of 2007, an expiration date of 12/07 is still valid).

Expiration dates < 1970 or > 2069 will return an error.

Accepts dates in the form:
M/Y
M/YY
M/YYYY

MM/Y
MM/YY
MM/YYYY

MY
MMY
MMYY
MYYYY
MMYYYY

"." (period) and "-" may be substituted for "/"

This function does not accept dates in the format "MYY" since there are cases where you cannot distinguish MYY and MMY (112, 102, etc.)

All characters but 1234567890, "/", "-" and "." are ignored.

trendymoniker@gmail.com for bug reports, requests, or questions.

Feel free to distribute and adapt as you wish.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: