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 (36 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.

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:

Under construction. Email me your wish list for improvements.