You could have ANY number of days, given that you restrict activdate to
and r.activdate <= intnx('days', "&datepmt."d, -90)
This puts a ceiling on acceptable activdate values, but no minimum.
Now, you could find the minimum activdate found in the data, so you would know the number of possible date values. But you would als have to know the maximum date value found to get the RANGE. And do a frequency of activdate to get the actual NUMBER of unique date values.
So what do you actually want?
... View more