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?
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?