Skip to Content
0
Former Member
Jul 02, 2009 at 10:44 PM

Evaluating dates to return next record.

26 Views

Find next record in range.

I have written a report using two tables, client and activity. each client can have many activities. I have filtered the report on the clients first actitivty which by default is called 'induction' and its assocaited attributes, date started and date ended.

This gives me a listing of all clients along with their initial activity. What i want to do is return the next activity that they undertook, this could be a number of things from football coaching, rugby coaching and other sports activities.

I would like to do this based on the end date of the previous activity i.e to return the next activity that occurred after the end date of the previous activity.

This will give me some flexibility should I want to customise it for searching for activity history.

Note that start and end dates are not contigious.

Using CR XI Rel2 SP5.