Comparison of Dates in Formula Language

Author: Tripp W Black

Created: 09/05/2000 at 09:23 PM

 

Category:
Notes Developer Tips
Formulas

s:=(Date2 - Date1);
m:=s/60;
h:= m/60;
days := @Integer(h/24);
d1:= @Modulo(h;24);
h1:=@Integer(h);
min1:=@Modulo(m;60);
sec1:=@Modulo(s;60);
result:=@If(days=0;@Text(d1)+" hrs "+ @Text(min1)+"
mins";@Text(days)+" days "+@Text(d1)+" hrs "+
@Text(min1)+" mins");
result

previous page

×