[thelist] SQL query help: dates

[Simon Perry]

Shiok Far-eastern Cuisine wrote:

>Hi folks.
>
>I'm a bit rusty on my SQL so I'm asking for help.
>
>I have an Access database with a list of customers and their personal info.
>This includes birthdays.
>
>I want to run a query that will return the names of customers whose
>birthdays fall in the 10 days from today. The name field is called
>CustomerName and the birthday field is called, well, Birthday.
>
>  
>
Hi

There is a great article on this problem and a very slick solution on 
Rudy Limeback's site [0].

Simon

[0] http://r937.com/birthdays.html