• msepeta
  • 0 Points
  • Member since 2010

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1

Hi All,


We utilize the Master Parent, Parent and Child relationships for our accounts.  All of our child accounts have a custom date field that we use to indicate when they first began service with us.


It is at all possible to create a Forumula to look at all of the Parent's child accounts and pull the the eariest date from the child's custom date field?


For example,


Parent A

Child 1 - Start Date 1/1/2010

Child 2 - Start Date 6/30/2010

Child 3 - Start Date 8/2/2010


The forumla would pull 1/1/2010 as the start date (since it is the earliest of the three) and put that as the start date for the Parent account.


Any ideas if this is possible through a formula?