Calc days in Xpages


is there a better way of doing this in Xpages ?  Getting totaldays between two dates  fields
 
t1 = dominoDocument1.getItemValueDate(“DATE”)
 t2 = dominoDocument1.getItemValueDate(“DATE1”)
 @Integer((@Date(t2) – @Date(t1)) / (60 * 60 * 24))/1000 +1
 its seams to work like this
Advertisements

3 thoughts on “Calc days in Xpages

  1. Remember, you have full access to the Java API, which is very similar to the LotusScript API, so you can pass the values to new instances of NotesDateTime and use .timeDifference. The result will likely be the same, but may also prove more accurate.

  2. Tim – something like this

    t1=dominoDocument1.getItemValueDate(“Date1”);
    t2=dominoDocument1.getItemValueDateTime(“Date2”);
    dominoDocument1.timeDifference(t1+t2);

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s