Notes/Domino 4 and 5 Forum

Hi all,

I have a form on which are 2 date fields:

dateActioned
datecompletedfld

I have a view which shows the above in 2 columns and I also have another column that shows the difference (in days) between the 2 dates. It has the following formula:

@Integer(dateActioned - datecompletedfld)/86400

I only have 2 entries in this view at the momment.

1. Has dateActioned = 18/5/2004
dateCompletedFld = 18/5/2004

In the view, my formula produces 1

2. Has dateActioned = 20/5/2004
dateCompletedFld = 21/5/2004

In the view, my formula produces 0

Any help on this would be very much appreciated.

Thanks

Jim