calculate the time

[rdevulapalli]

local numbervar sec:=datediff("s",{EMP.EMP_INS_YMDHMS},{DEPT.DEPT_INS_YMDHMS});
local numbervar days:=0;
local numbervar hr:=0;
local numbervar min:=0;
local numbervar calc;

calc:=truncate(sec/(24*3600));
days:=calc;

calc:=truncate(sec/3600);
hr:=calc;

calc:=truncate(sec/60);
min:=calc;

sec:=sec mod 60;

totext(days)+"Day "+totext(hr) +"Hrs "+totext(min)+"Min "+totext(sec)+"Sec";