Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
6 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 display the date in appointment 2 if the date in appoint 1 is prior than the current date. then if appointment 2 is prior to the current date i want to display appointment 3. Does anyone have any help on writing out this type of formula?
Formulas and functions

2 Replies

Sort By
  • AroofShaik's avatar
    AroofShaik
    Qrew Trainee
    6 years ago
    Hi, 
     You can use 

     Workdays formula for calculating next appoint date.

    WeekDayAdd([Start Date],[Business Days]).

    Ex.

     If your taking appointment date for next week in working day 


    Syntax 

    Start date : 05-Sep-2018


    business day : +5( it will calculate next 5 working date from calendar )

    >> 12-Sep -2018 display as next five working date.



  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 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])