Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Roll up unique date fields

Solved
Jump to Solution
4515 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to roll up a bunch of different dates.
I need them comma separated in an array, so I later can replace the comma with a line break to display them on top of each other.

I’ve tried with
ARRAYUNIQUE(DATETIME_FORMAT(values, ‘DD-MM-YYYY’)) in my roll-up field

However this only works if there is only one date, but when there is more dates then they return ERROR.

Is there a way around this?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

The problem you’re running into is that you’re passing values into DATETIME_FORMAT(). The values keyword represents the array collected by the rollup field, and DATETIME_FORMAT() can only process a single datetime item, not an array full of them.

What I suggest is making a formula field to format the dates in the table where the rollup is pulling from, and rolling up that formula field instead of the raw date field. Then you can just use ARRAYUNIQUE(values) for your aggregation formula, and it should give you what you want.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

The problem you’re running into is that you’re passing values into DATETIME_FORMAT(). The values keyword represents the array collected by the rollup field, and DATETIME_FORMAT() can only process a single datetime item, not an array full of them.

What I suggest is making a formula field to format the dates in the table where the rollup is pulling from, and rolling up that formula field instead of the raw date field. Then you can just use ARRAYUNIQUE(values) for your aggregation formula, and it should give you what you want.

Thanks Justin…

Thats works