find birthday

[eluser]Bigil Michael[/eluser]
thanks for your reply

but this is not the required result

i want to find out the birthdays

eg: find the persons with birthdays within 2011-02-01 and 2011-02-03

then the result must be like this

Code:

persons with birthdays  within
                        2010-02-01..............2010-02-03
                        2009-02-01..............2009-02-03
                        2008-02-01..............2008-02-03
                         .
                         .
                         .
                         .
                        1950-02-01..............1950-02-03

i think now u got the idea
here year is not important only day and month are important
so i generated birthday and birth month....

if possible please help?? urgent
any other method to calculate the result is also accepted...