[thelist] SQL query help: dates

Simon Perry thelist at si-designs.co.uk
Fri Feb 18 03:38:07 CST 2005

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.

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


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

More information about the thelist mailing list