Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
KIBL

# 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.

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:

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 :-/

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?

KIBL

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