I have a form on which are 2 date fields:
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.