TimeDifference in formula language? Views?

HCL Domino Domino Forum
1

Hi All

Is it possible to find number of days between two days in a view.

One view shows a some documents which have a DatedCreate and DateCompleted fields (date/Time). I want to display difference in these two dates.

One possible solution would be to have a hidden computed number field on the form which is populated using TimeDifference function of Lotus Script.

As this is a production DB, I would prefer to a formula solution so that I can calculate the difference between the two dates in the view only.

Can anyone please suggest a solution.

Thanks in advance

Alpna

2

Subject: TimeDifference in formula language? Views?

Subtracting one date from another in the formula language gives the difference in seconds, so the difference in days would be (date1 - date2)/86400. You’ll probably want to round that off, but it’ll work just fine in a column value formula.

3

Subject: RE: TimeDifference in formula language? Views?

Cool! Thanks a lot.