Arrrayunique for Date (lookup field)

I have 2 fields


Field 1: Date (lookup)
Field 2: I wanna if the date (and time) Duplicate , just show 1 value date time . If it has 2,3 different date, i wanna show all of them
And i use this formula and it shows error, what am i missing ?

Welcome to the community, @Kendy511!

Your formula is trying to format an entire string of multiple dates, as opposed to an individual date.

However, even if you moved the DATETIME_FORMAT inside the parenthesis, it still wouldn’t work, because one of the huge limitations of working with arrays in Airtable is that the array functions are so limited in their functionality that you can’t add anything else to those array functions. You can only use them as-is.

So your formula must stay as: ARRAYUNIQUE(values)

However, what you can do is go back to your OTHER TABLE and create a formula field there that formats the date the way you want there.

Then, in this table, change your Rollup field to point to the formatted date field in that other table.

1 Like

Well, i’m appreciate your suggest, I tried to go back to OTHER TABLE with single Date time like this Annotation 2020-06-23 211038
And create a new column nearby to convert Date time to value. So what exactly formula I can use to change Date time format to values but still keep the display Date & time as the old one ? @ScottWorld

In your other table, create a formula field that looks like this:

DATETIME_FORMAT({Date Field},'DD-MM-YYYY')

(Replace the words “Date Field” with the actual name of your date field.)

Then, back in your original table, create a rollup field that rolls up this new formula field.

well, That seems an normal work but need a lit step to convert . Thank you for your helps!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.