+ Start a Discussion
KIBLKIBL 

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

 

Help!

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?  

 

KIBLKIBL

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