Subtracting date fields in xpages

Question

Can anyone help me to come up with a formula to: (1) subtract dates in xpages [not in lotus client] I am a beginner in xpages with no experience in xpages javascript or xpages expression language.

(2) If possible can anyone also help me compute for the Business Days in xpages because there is no @BusinessDays function in xpages.

Hope someone could help me. Many thanks in advance!

2) @Business days - here you go: techmix.net/blog/2011/09/17/count-the-business-days-in-xpages — pipalia

Fred Fred · Accepted Answer · 2012-01-18T19:06:58

(1) subtract dates in xpages [not in lotus client] I am a beginner in xpages with no experience in xpages javascript or xpages expression language.

I found this on an IBM wiki site, tested and it works:

timeDifference

This computed field returns the number of days since the current document was created.

var doc:NotesDocument = currentDocument.getDocument();
var created:NotesDateTime = doc.getCreated();
var now:NotesDateTime = session.createDateTime("Today 12");
now.setNow();
var days:int = now.timeDifferenceDouble(created) / 86400; // 86400 seconds in a day
return "This document was created "  + Math.floor(days) + " days ago."

Subtracting date fields in xpages

2 Answers