Trying to create a birthday list, using advanced sorting

I'm trying to create a CB list with upcoming birthday, so I need the sorting to ignore the year of course.

I found some sql examples online, but I can't get them working:

This doesn't work, and it doesn't consider the current date:
month(ue.'cb_birthday') ASC, dayofmonth(ue.'cb_birthday') ASC

datepart(dy,dateadd(d,- DATEPART(dy, getdate()),ue.'cb_birthday' ))

It could be way out of scope for the product, but it would be nice to have the list show somewhere on the page

Ordering by birthday is just a matter of using MONTH then DAY order by on the birthdate if you want to exclude year otherwise you have to normalize the year and order by the result. Gets a lot more complicated to order by upcoming birthday. See the below.

www.google.com/search?q=sql+order+by+upcoming+birthdays

stackoverflow.com/questions/7343807/mysql-query-to-sort-upcoming-birthdays-based-on-current-date

The Advanced usage under Order By lets you directly add to the query so you'll be able to do this, but you'll need to provide the SQL. Likely won't be very efficient though.