>Hilmar,
>
>I'm pretty sure as long as ldStart < = ldEnd that it'll work across a year boundary. Final testing is up to you. *bg*
>
>>Looks interesting - I have to analize it later. Do you think that would fail for a date range spanning end-of-year? E.g. {^2009-12-30} to {^2010-01-05}. If it does fail (and works otherwise, as I think it would), I could code that case separately - dividing into two ranges.

Not, If I am born on 3 Jan. The query will test for DATE(2009, 1, 3) BETWEEN DATE(2009, 12, 30) AND DATE(2010, 1, 5), just because YEAR(ldStartDate) is used. The same is if YEAR(ldEndDate) is in use :-)