Skip to main content

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

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


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


Many Thanks Mohamed

It works well !

Benoît


Glad it did.


Please mark your question as answered 🙂


Reply