Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
if isnull({EmployeePos_Stat_Curr.LastHireDate}) then 0
else If cstr({EmployeePos_Stat_Curr.LastHireDate},"MMdd") <= cstr(CurrentDate,"MMdd") then
Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate})
else
Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate}) - 1
numbervar n;
if isnull({EmployeePos_Stat_Curr.LastHireDate}) then 0
else If cstr({EmployeePos_Stat_Curr.LastHireDate},"MMdd") <= cstr(CurrentDate,"MMdd") then
n := Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate})
else
n := Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate}) - 1;
if n > 0 then totext(n,0) & " Yrs"
else totext(datediff("m",{EmployeePos_Stat_Curr.LastHireDate},currentdate),0) & " Mo"
if isnull({EmployeePos_Stat_Curr.LastHireDate}) then 0
else if Datediff ("yyyy",({EmployeePos_Stat_Curr.LastHireDate}}, CurrentDate) < 1 then
"Months "& Datediff ("m", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)
else
"Years "& Datediff ("yyyy", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)