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.

Under construction. Email me your wish list for improvements.