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 in another field in different table.

eg.

Cust     SchedDate

ABC1     02/10/2013

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.

Please be more clear but if you want the next date, that means, if we have the today date 2013/02/12, then the next date would be tomorrow, like 2013/02/13. For this the calculation is below:

 

GetAsDate ( (GetAsNumber ( Date ) + 1) )

 

The resultant field must be calculation and Calculation result must be displayed in Date.

Hi

 

You can relate the customer visit table Date Field with other table Date field using an (<) relationship

and can use a portal of the other table's containing one row with no scroll bar to show the next date field record. (portal sorted in (Date) ascending order.)