Formula help on Dates

HCL Domino Domino Forum
1

I have form where a field called Answered Date (Date Field) contains the date that field was last modified. Examle 1/15/2011

I need to make a field that takes the current date and then calculates the difference between it and the Answered Date.

So if the current date is 1/21/2011 and the Answered Date is: 1/15/2011 this new field would return a 6.

2

Subject: Date/Time Math

If they are both date fields you can do the following:

(@Date(AnsweredDate) - @Date(OtherDate) ) / 86400

@Date will ignore TIME component. Subtracting the two gives you seconds. Divide by 60 sec/min x 60 min/hr x 24hrs/day = number of days.