Agreed, nice code.

But if it's a birthday, wouldn't it be reasonable to use the current date + 1 as the cutoff, since there won't be future birthdates but someone could conceivably be 90+ years old?

declare @mycutoff date

set @mycutoff = dateadd(day, 1, getdate())

--yes, I know you can just use getdate()+1, but I prefer to explicitly use DATEADD

...