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.

Convert appointment dates to days until last appointment

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

I have two tables.

Table 1: Client
Table 2: Appointments

Each appointment is tied to a client. I’m looking to see how many days from the client’s last appointment.

E.g. the client’s has 3 appointments however his last appointment was 1/1/2020 then the cell would display ‘14’ since that was 14 days ago.

Any ideas?

1 Solution

Accepted Solutions
Zollie
10 - Mercury
10 - Mercury

Edit: Nevermind - what you’re requesting is possible via roll-up fields.

Clients
Names (single line text)
Aaron Schiff

Appointments (linked records)
11/14/00,11/13/00,11/14/01,11/12/02

Last Appointment (roll-up)
11/12/02
Settings: Sort by 'max' on date field in Appointments

Time Since Last Appointment (formula)
6272
DATETIME_DIFF( TODAY(), {Date}, 'days' )

Appointments
Date (date field)
11/14/00
11/13/00
11/14/01
11/12/02

See Solution in Thread

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

Edit: Nevermind - what you’re requesting is possible via roll-up fields.

Clients
Names (single line text)
Aaron Schiff

Appointments (linked records)
11/14/00,11/13/00,11/14/01,11/12/02

Last Appointment (roll-up)
11/12/02
Settings: Sort by 'max' on date field in Appointments

Time Since Last Appointment (formula)
6272
DATETIME_DIFF( TODAY(), {Date}, 'days' )

Appointments
Date (date field)
11/14/00
11/13/00
11/14/01
11/12/02

Awesome, works great, thanks!