Jul 25, 2018 01:05 PM
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!
Aug 05, 2021 12:12 PM
As the aggregation formula for the Roll-Up field: ARRAYJOIN(values, “\n”)
Oct 25, 2024 03:37 AM
Thank you for this! It worked on my table too.