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

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