Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Example:
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.
If dates are in same field use
Interval(Today() - Min(StartDate),'D')
Interval(Today() - First Date(1/1/2014),'D') will give you the age in days...
In your script define an Age field:
let vToday = Today();
load
$(vToday)-StartDate as Age
Then you can have the max age of a group as:
sum(aggr(max(Age),Group))
I do not know the name of your fields or your tables, so you have to adapt this to your application
Hope this helps
Regards
SKG
Age(Today(),FirstSortedValue(Date,Date))
If dates are in same field use
Interval(Today() - Min(StartDate),'D')
Hi Bradley .
is what you need?
Regards!
DD