Discussions

Expand all | Collapse all

Help with date formula to display next appointment date

  • 1.  Help with date formula to display next appointment date

    Posted 09-05-2018 04:01
    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?


  • 2.  RE: Help with date formula to display next appointment date

    Posted 09-05-2018 04:06
    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.





  • 3.  RE: Help with date formula to display next appointment date

    Posted 09-05-2018 04:23
    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])