I have a group that has two start dates, and I need to calculate the age of the group by subtracting the first start date from Today(). I have used firstsortedvalue some, but that is selecting an amount that goes along with the first date.
First Date: 1/1/2014
Second Start Date: 3/1/2014
Need a formula to calculate Today() - First Date(1/1/2014)= Answer.
Any help you can offer will be greatly appreciated.
In your script define an Age field:
let vToday = Today();
$(vToday)-StartDate as Age
Then you can have the max age of a group as:
I do not know the name of your fields or your tables, so you have to adapt this to your application
Hope this helps