Help

[SOLVED] DATETIME_FORMAT in Rollup Field?

8537 11
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”)

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