Calculate Years of Employee between a date/time field and today

This formula will do years and months. But I or someone would need to get inspired to get the days working too.

var date MyDate = [My date];
var text Years = ToText(

Year(Today())-Year($MyDate)
-
If(
Month(Today())<Month($MyDate)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0));

var text Months =  If(
Month(Today()) > Month($MyDate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) > Day($Mydate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) < Day($Mydate), "11",

ToText(12-(Month($mydate) - Month(Today()))));

var text RawResult=
$Years & "yr" & If ($years <> "1","s") & " " &   $Months & "mth" & If($Months<>"1","s");

If($years<>"" and $Months<>"", $RawResult)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------