Skip to main content

Hi all--

We are a publishing company and we sometimes publish the same content multiple times throughout the year. We have a field set up "Publish Date" that shows all of the dates. The problem is when I try to have these feed into our general publishing calendar view, I can either only choose between the Minimum date (the first date) or the Maximum date (the last one), I can't figure out how to show both dates on the calendar (without having it span across the entire time in between the two dates). Is there possibly a way to separate the dates into separate entries and enter them into the calendar that way? Thanks in advance!

Hmm, perhaps you could try hardcoding a bunch of rollup fields like so:


And the formulas would be variations of the following, where you update "1,1" to "2,2" etc:

 

DATETIME_PARSE(
ARRAYSLICE(values, 1,1) & ""
)

 

And in your Calendar view you'd use multiple date fields:

Link to base


Got it, I think that worked! Thanks so much!!


Reply