Help

The Community will be temporarily unavailable starting on Friday February 28. Weā€™ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: [SOLVED] DATETIME_FORMAT in Rollup Field?

3072 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Shayne_Bundy
6 - Interface Innovator
6 - Interface Innovator

I cannot get DATETIME_FORMAT to work in a Rollup Field. There are multiple dates present in the Rollup Field, and each displays correctly when NOT using the DATETIME_FORMAT
I am attempting: DATETIME_FORMAT(ARRAYJOIN(values, ā€œ\nā€), ā€œM/DD/YYYYā€)

But that results in an #ERROR! when there are multiple dates present in the Rollup. It works correctly when there is only one date present in the Rollup Field.

Iā€™ve found a couple topics on this same issue, but no resolutions. Thank you!

11 Replies 11

As the aggregation formula for the Roll-Up field: ARRAYJOIN(values, ā€œ\nā€)

Shuyen
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you for this! It worked on my table too.