I try to make a list of people that are having their birthdays for a certain period of time.
I have the birthdate in a datefield in mysql, how can I get a resultset of people that will have birthday today and the next 6 days (or 7 or 8 etc) AND order them by date and not birthdate.
I know it can be done by using a lot of code, but I guess it could be done in 1 or 2 lines of code.
It has to work also if I want a list for the next 7 days when its 30 december or so, so ordering by just dateparts would not work in that case