Combining Two Formulas

[makasabian]

Hi! I am trying to solve the following:

I have a lookup field that lists multiple dates multiples times (the same day in each respective record). Like so: 10/10/2022, 10/10/2022, 10/10/2022, 10/10/2022. This is the "Move In Date ~ Expansion" Field. 

I only want one date listed and clean like so "MM-DD-YYYY". So I created a Formula Field ("Move In Date ~ Expansion (Calculation)" Field and did an ARRAYUNIQUE formula, however, it shows up with additional 0's and is not clean. How can I adjust this formula so that it lists the date of the lookup field only once and clean like so"MM-DD-YYYY"? Or does anyone have any other solve here? Thank you!

[kuovonne · Accepted solution]

Use a rollup field instead of a lookup field. Since all of the dates are the same, you can use the rollup formula 

MAX(values)

[makasabian]

Thank you so much! That worked!