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.

How to Format Dates in a Rollup field with multiple dates

Topic Labels: Formulas
Solved
Jump to Solution
2686 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Scribbles_
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone,
I've been searching airtable forums for hours yet I can't find a solution that clearly explains what I need to do to achieve my desired results. There are different answers talking about using MIN() or something other formula, but I can't get it to work for me.

Scribbles__0-1686012770090.png

I have a lookup field that pulls date entries from another table, but there are many duplicate entries I can't remove.
So I used ARRAYJOIN(ARRAYUNIQUE(values), '\n'in the column beside it to rollup the fields and finally remove the duplicate entries. The problem is there are times attached to all entries as "T00:00:00.000Z" and all 
I want is the date part. For the life of me I can' figure out a way to get rid of them. Is there a way to achieve this result somehow? or to Format the dates?
Any help explaining what I need to do exactly would be helpful, thank you.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

In the linked table, have a formula field with DATETIME_FORMAT() to convert the date field to a text string. Then roll up the formula field.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

In the linked table, have a formula field with DATETIME_FORMAT() to convert the date field to a text string. Then roll up the formula field.

Scribbles_
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Kuovonne! 
I implemented it and finally got what I wanted.

The linked table:

Scribbles__0-1686034799359.png

The result:
I used this to rollup the fields like this

 

 

ARRAYJOIN(ARRAYUNIQUE(values), '\n')

 

 

Scribbles__1-1686034843748.png

Thank you for your answer.