Evaluator Column - Precise Ages

For whatever its worth. I use this implementation.

secs = Age(modifieddate, "s");

if (operation == "sort")
	return secs;

ss = secs Mod 60;
mm = secs / 60 Mod 60;
hh = secs / 60 / 60 Mod 24;
dd = secs / 60 / 60 / 24 Mod 365;
yy = secs / 60 / 60 / 24 / 365;

if(yy!=0)
{
	return yy + (yy == 1 ? " year" : " years");
}
else if(dd!=0)
{
	return dd + (dd == 1 ? " day" : " days");
}
else if(hh=0)
{
	return hh + (hh == 1 ? " hour" : " hours");
}
else if(mm!=0)
{
	return mm + (mm == 1 ? " min" : " mins");
}
return ss + (ss == 1 ? " sec" : " secs");
1 Like