Next Item in String

I'm creating a report and wish to use field {Session_Starts.Special_Date}. It is a string field and I want to create a formula where this field automatically draws in the next string item.
Example if the special date is March 26, 2007, I want it to use the next string item, which is April 9, 2007. I can't use +14, because the next string item isn't always +14 days.
Can anyone help me with the formula to use?
Thanks so much in advance!So you want the {Session_Starts.Special_Date} value of the next record? Use the Next function! Look in the help.

Next IsNull help required

Hi,

I have written a simple formula to identify the last address in a sequence, in a multiple address report which is sorted in alphabetical order:

If next ({address}) <> {address} then 1 else 0

This works fine, however, the very last record in the report 'should' have a value of 1 but doesn't because obviously there is no Next record.

I have therefore tried adding the following line (and variations on the same theme!) but cannot achieve what I want.

If Next ({address}) <> {address} then 1 else
If Next IsNull ({address}) then 1 else 0

I presume this is not possible as there is no Next record. Can anyone suggest a way around this?

Thanks.OnLastRecord|||Thanks. My report now works. Apologies for being a numbskull!