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.

Format date in Rollup field

2697 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Eshin_Godfrey
4 - Data Explorer
4 - Data Explorer

Using the ARRAYJOIN option for a Rollup field. The result, as wanted, is a comma separated list of dates. These dates include time which I don’t need. Want yyyy-mm-dd formatting for the dates, which is the way they’re formatted in the original table. I tried changing the Rollup field to Date yyyy-mm-dd which formatted as I wished but only displayed the first date of the array.
Anyone know of a way to format dates in a Rollup array?
Thanks

2 Replies 2
Andy_Fletcher
5 - Automation Enthusiast
5 - Automation Enthusiast

Did you ever figure this out? It’s kinda driving me crazy right now. I can’t even figure out if there’s a way to split the array of dates, format each of them then rejoin…

I was evaluating airtable at the time. Didn’t resolve this.