What would be the formula for calculating an average date?
That's a good question - if I have 5 rows with March 1st and one with March 31st (?), is the average somewhere around the 5th?
If this is the answer then date(avg(float([date field])) should work
Hi, yes this is to calculate the average length of time a page has been active on a website against today's date, or "average page age"?
Alex, thanks, I'm getting "The calculation contains errors" with date(avg(float([date])) , am I missing something implicit to your formula?
Did you change the name of the variable to your date field?
Though by the sounds of if you want something different like:
avg(datediff('day',[your date field],today()))
Thanks, this formula seems to be working perfectly