function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Determine the latest of 3 date fields and then caculate time between

I need to run a report showing me the number of dates between the last approval received and when the order got entered.  I believe I need to create a fomula field to do the following:


I have 3 milestone date fields on the Opportunity.


Received Approved Drawing

Received confirmations/Approvals

Received VFD’s


I want to determine what the Latest of these 3 dates are and then calculate the time between the Later Date and the Order Entry Date field.


For example:

Received Approved Drawing  07/07/10

Received confirmations/Approvals 07/07/10

Received VFD’s 07/12/10


Order Entry Date07/15/10


7/12/10 is the latest date of the three so caculate the days between 7/12/10  and 7/15/10 (starting from 7/13/10 because they could have received it late in the day) = 3 days



Steve :-/Steve :-/

Are there currently any rules in place as to the order/precedence in which the 3 Dates are entered and their values? Or is it a "free for all" when any of the 3 Date fields can have any value entered at any time?  



It is a free for all.  When all 4 fields are populated, that is when I want the date caculated.