Hello,

Thankyou for the bottom solution, it seems to work well, there are just a few instances were there is still a null start date and null end date. Its turns out that only a status of 'nfa' can be applied therefore closing the referal thus giving us no start date to play with. We can how ever use a field in the referral table 'refstartdate' as the start date?

Could this be built into the query suggested?

and just focus on the end date issue?

Cheers

Jon