Brian Dunning's FileMaker Custom Functions

Format_Expr ( ExpirationDate )

Formats a credit card expiration date, returning it in the form "MM/YY"

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

Kevin Bache   Kevin Bache
None
www.none.com

Share on Facebook Share on Twitter

  Sample input:
Format_Expr ( 5/5 )
Format_Expr ( 88 )
Format_Expr ( 123 )
Format_Expr ( 3.2006 )
Format_Expr ( 1307 )
  Sample output:
05/05
08/08
12/03
03/06
Error

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

------------------------------
Format_Expr version 1.0
------------------------------
Formats a credit card expiration date, returning it in the form: "MM/YY".

Dates < 1970 or > 2069 will return an error.

You can edit the marked line at the bottom of the function to change output format.
You can edit the marked error_message variable to change the value returned if there's 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.