Skip to main content
Solved

How to format a rollup field to date?

  • April 18, 2020
  • 3 replies
  • 46 views

Forum|alt.badge.img+4

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

Best answer by Mohamed_Swella1

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

3 replies

Mohamed_Swella1
Forum|alt.badge.img+17

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


Forum|alt.badge.img+4
  • Author
  • New Participant
  • April 18, 2020

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


Mohamed_Swella1
Forum|alt.badge.img+17

Many Thanks Mohamed
It works well !
Benoît


Glad it did.

Please mark your question as answered :slightly_smiling_face: