>>I am sure this has been discussed before, but I never paid much attention to the issue... until now, when I need it.
>>
>>From a list of people with birth dates, how do I find out who has a birthday within a certain range of dates - e.g., the current week?
>>
>>I could write some kind of loop, or complex logic, but I suspect there must be some easier way.
>>
>>TIA,
>>
>>Hilmar.
>
>
>select * from mytable where week(mytable.dob)=week(date())
Thanks, but I don't think that will be very accurate - considering that the first week of the year may start on different dates.
Also, "current week" was only an example - I want to have the ability to include an arbitrary date range.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)