Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to format a rollup field to date?

Topic Labels: Formulas
Solved
Jump to Solution
827 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I can’t find the way to format properly to date a rollup field. The formatting tab return that it’s not a date field. I have that : 2020-10-05T00:00:00.000Z and I want just that : 2020-10-05

Yet, the field rolled up is a date and the aggragation formula is ARRAYUNIQUE(values)

Thanks in advance

1 Solution

Accepted Solutions

Hi @benoit_razy,

Try the rollup value Min() or Max(). You are rolling up an Array, which means its sees it as text.

BR,
Mo

See Solution in Thread

3 Replies 3

Hi @benoit_razy,

Try the rollup value Min() or Max(). You are rolling up an Array, which means its sees it as text.

BR,
Mo

Many Thanks Mohamed
It works well !
Benoît

Glad it did.

Please mark your question as answered :slightly_smiling_face: