Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 22, 2023 02:56 AM
Hi all,
I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.
Any suggestions? (thanks in advance!)
Jan 22, 2023 11:36 AM
AVERAGE(values) does not work with date fields.
Can you explain how you want to calculate an average date?