How to calculate the date difference between 2 dates using Lotus Notes Fourmular
If you are using lotusScript you can use either of these:
Returns the difference in seconds as a double
difference = notesdatetimeobj.TimeDifferenceDouble(othernotesdatetimeobj)
Returns the difference in seconds as a long
difference = notesdatetimeobj.TimeDifference(othernotesdatetimeobj)
If you are using @formulas you can just substract one date from the other and it will return the difference in seconds as well:
difference := date1 - date2;
Hope that helps.
How can I change the caption of a button using LotusScript/Formula?
I need to call a lotus script function from Lotus Formula. The function returns a result. I do not just want to run a script which does not return any value. This is for Lotus Notes 7. Example ...
My Lotus Notes document has a rich text item that stores an attachment. I want to edit the attachment and after this to save the attachment back to the Lotus Notes document. This is the script that ...
Does anyone know of a way to mark the current email as read using an @command?
I created Lotus Notes database for HR Department. I entered field Join date. Also entered field “Total Service Period”. I want get the calculated Number of Years, Month and Days of service in to “View”...
How to calculate the date difference between 2 dates using Lotus Notes Fourmular
I m modifying an existing Lotus view to include a field from another form. I first appended a new column and set it to the desired field. However, after I refreshed, the new column was blank even ...
I m new to Lotus development and I need to create a view that shows where the user is manager of another database besides its own mail. Thanks in advance for any help.