Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
7 years ago

Help with date formula to display next appointment date

I have 10 date fields to list appointment dates in chronological order. We can call them appointment 1, appointment 2, appointment 3, etc. I would like to create one formula date field that would disp...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Brian,
The formula for [Next Appointment Date] would be

IF(
[Appointment 1] > Today(), [Appointment 1],
[Appointment 2] > Today(), [Appointment 2],
[Appointment 3] > Today(), [Appointment 3],

etc

[Appointment 10] > Today(), [Appointment 10])