Manage Learn to apply best practices and optimize your operations.

Difference Between Two Dates

The following formula will allow you find the difference between two dates on a
document. This formula was used in a column with @Modified & @Created but
substituting different Date/Time field names or @Functions for those values
below will allow it to be used for any two dates.

temp := ((@Modified - @Created)/60)/60;
temphours := @Left(@Text(temp); ".");
tempminutes := @Left(@Right(@Text(temp); "."); 2);
tempdays := @TextToNumber(temphours)/24;
temphours2 := @Left(@Right(@Text(tempdays); "."); 2);
hrspercent := @TextToNumber(temphours2)/100;
hours := 24 * hrspercent;
days := @Left(@Text(tempdays); ".");
percent := @TextToNumber(tempminutes)/100;
minutes := 60 * percent;
@If(days = ""; "0 days, " ;@Text(days) + " days, ") +
@If(hours = ""; "0 hours, "; @Text(@Round(hours)) + " hours ") + @If(minutes =
""; "0 minutes";@Text(minutes) + " minutes")

This column formula will result in a message being displayed in a format
similar to this example.
Example: 5 days 10 hours 37.5 minutes

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...