Q
Problem solve Get help with specific problems with your technologies, process and projects.

# Calculating time difference in Formula language or LotusScript

I need to calculate the time difference between two dates in Formula language or LotusScript and then return the result in the format of "x months and y days." Do you know of any scripts or @Formulas that can do this?
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:[email protected] (year1=year2;
month2 - month1;
((year2-year1)*12) + month2 - month1);
months:[email protected](day2<day1;
tempmonth - 1;
tempmonth);
days:[email protected](day1<=day2;
day2 - day1;
daysinmonth + day2 - day1);
"sample: " + @text(months) +
" months and " + @Text(days) + " days."
```

#### Dig Deeper on Lotus Notes Domino Formula Language

• Favorite iSeries cheat sheets

Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

• HTML cheat sheet

This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

• Carol Woodbury: Security

Carol Woodbury

Close