I've just looked at the data that the query is looking at and the time part of the datetime fields are always zero, so there's no need to do this work to strip the time out - they should have been able to compare the fields without any messing about.

I'll have a play with slightly healthier ways of comparing dates where there is a time to consider/remove.

Thanks for the assistance Gail, Allister.

BrainDonor.