Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

Year4Digit ( ThisYear ; CutOffYear )

Convert a 2 digit year into 4 digits.

  Average rating: 4.8 (22 votes) Log in to vote

Tim Cimbura - Show more from this author LuminFire http://luminfire.com

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

/* Anything below the cut off year will be considered to be 20XX Anything above the cut off will be 19XX */ Case( Length(Trim(ThisYear))=2 and GetAsNumber(ThisYear) < CutOffYear; "20" & Left(ThisYear; 2); Length(Trim(ThisYear))=2 and GetAsNumber(ThisYear) >= CutOffYear; "19" & Left(ThisYear; 2); Trim(ThisYear)) Click to copy

This custom function will take a 2 digit year and convert it to a four digit year. Based on a specified 2 digit cut off year it will determine if the actual year is in the 20th (19XX) or 21st century (20XX).

 

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 20 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: