Rollup latest date - known issues?

[Matt_Holmes]

Hi all,

I’m using Rollup to find the latest date in a custom CRM. The Max(values) approach always works fine, but in this instance I cannot select “date” as an option under the format menu in Rollup.

Any ideas? Many thanks in advance!

Cheers,
M

[ScottWorld]

I am not seeing that incorrect behavior on my end. I am seeing the proper behavior. I would recommend opening a ticket with support@airtable.com.

[ScottWorld · Accepted solution]

Oh, I just noticed that your term “Values” is in purple. This purple color represents a field name. You probably have a field named “Values”, which triggers a massive bug in Airtable where rollup fields can never be used. The only way to workaround this is to never name any of your fields “Values”. Trust me, there is no shortage of bugs in Airtable. Lol.

[Matt_Holmes]

Scott, you just saved my life. THANK YOU!