Calculation to find next date

[cxkrod]

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.

[fmbug]

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.

[Priyabrata]

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.)