MonthsToYears ( Months )

Convert number of months to year format i.e. 60 to 5yrs

Average rating: 4.3 (27 votes) Log in to vote

Tony Tanevski - Show more from this author
Hi-Voltage
http://www.hi-voltage.com.au

Sample input:

MonthsToYears(60)
MonthsToYears(12)
MonthsToYears(70)
MonthsToYears(13)

Sample output:

5 Yrs
1 Yr
5 Yrs, 10 Mths
1 Yr, 1 Mth

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

Case(not IsEmpty(Months) and Months >=0 and months <> "?";

Let(
[
    xYears = Int(Months / 12);
    xMonths = Case(Months - (12 * xYears) > 0; Months - (12 * xYears))
];

    Case(
      xYears = 1; 
          "1" & Case(xMonths <> 0; " Yr"; " Year");
      xYears > 1;
         xYears & Case(xMonths <> 0; " Yrs"; "Years")
    )

    & Case(xYears <> 0 and xMonths <> ""; " , ") &

    Case(
      xMonths = 1;
           "1" & Case(xYears <> 0; " Mth"; " Month");
      xMonths > 1;
           xMonths & Case(xYears <> 0; " Mths"; " Months") 
    )

)
)

Convert number of months to year format i.e. 60 to 5yrs

Comments

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

MonthsToYears ( Months )

Comments

Support this website.

Support this website.