AnsweredAssumed Answered

Calculation to find next date

Question asked by brad_premier on Feb 11, 2013
Latest reply on Feb 11, 2013 by Malcolm

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.

Outcomes