Require a date field entry to be after a date ente...

[gospelsoulcare]

I am trying to create a formula that will take the latest date from a linked field (Appointments) and enter the latest date in a new field called "Last Appointment." I tried to generate a formula using the AI which gave me this formula:

DATESTR(ARRAYSLICE({Appointments}, -1, 1))

but it keeps coming back with an ERROR. 

Any help would be appreciated.

[ScottWorld]

To do this, you would need to create a Rollup Field that points to your linked record field, and then you would choose the appointment date from the field drop-down.

Then, for your Rollup Field's formula, you would use this formula:
MAX(values)

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld