3 Replies Latest reply on Feb 11, 2013 6:33 PM by Malcolm

    Calculation to find next date

    brad_premier

      I have a list of customers with multiple visit dates that could be scheduled a year in advance. I want to return the next date from today

      eg.

      Cust SchedDate

      ABC1 02/12/2013

      ABC1 02/26/2013

      ABC1 03/12/2013

      XYZ1 02/13/2013

      XYZ1 03/13/2013

       

      Cust ABC1 would show 02/12/2013 (today)

      Cust XYZ1 would show 02/13/2013

       

      Any ideas would be appreciated.