Skip to main content
Question

Help with date formula to display next appointment date

  • September 5, 2018
  • 0 replies
  • 44 views
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?
    This topic has been closed for replies.

    • AroofShaik
    • Registered
    • September 5, 2018
    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.



    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])
    Terms & ConditionsAccessibility statement