Just to say thanks to everyone for the tips on the date calculation.

All suggstions were much more sensible than my own!

Query still slow though...

Ken

Hi Kenneth.

Query plan is identical on both queries.

Cheers for the tip on the date calculation.  Though that part of the query takes no time at all.

The slowness only happens when...