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

SearchWindowsServer
Search400
  • 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

SearchDataCenter
SearchContentManagement
Close