To continue reading for free, register below or login
To read more you must become a member of SearchDomino.com
I used a formula to calculate the difference. This does not include code for leap year and assumes that date1, the first date, is always earlier than date2. Here's the formula for a text field.
year1 := @IF(date1=""; 0; @Year(date1));
year2 := @IF(date2=""; 0; @Year(date2));
month1:= @IF(date1=""; 0; @Month(date1));
month2:= @IF(date2=""; 0; @Month(date2));
day1 := @IF(date1=""; 0; @day(date1));
day2 := @IF(date2=""; 0; @day(date2));
daysinmonth := @IF(date1="";
0;
@Select(month1;31;28;31;30;31;
30;31;31;30;31;30;31));
tempmonth:=@IF (year1=year2;
month2 - month1;
((year2-year1)*12) + month2 - month1);
months:=@IF(day2<day1;
tempmonth - 1;
tempmonth);
days:=@IF(day1<=day2;
day2 - day1;
daysinmonth + day2 - day1);
"sample: " + @text(months) +
" months and " + @Text(days) + " days."
|
