The form I am working with in ES4 has a dynamic table with the ability to (1) add rows - lets call these master rows- and (2) add rows within a subform on each of those master rows - lets call these child rows. Each of the child rows within a master row contain dates. I would like to calculate the Sum of the number of dates between the earliest and latest dates specified in the child rows date fields for each master row.
How would I go about having ES4 look for the earliest and latest dates? Any scripting ideas?