You need to sign in to do that
Don't have an account?
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!
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.