Month and day for birthdaylist

Hi!
I have a customfield named cb_birthday.
I want to create a list, sorted bei month(birthday) and day(birthday).
So I created two query-fields and used the sql-functions month() and day().
It works to show month and day on a tab or in the list, I even can select them for sorting, but it has absolutly no effect, the list is shown in the order of database entries. :S

Thanks for any advice!!
Stefan

stefan.wulff wrote: Hi!
I have a customfield named cb_birthday.
I want to create a list, sorted bei month(birthday) and day(birthday).
So I created two query-fields and used the sql-functions month() and day().
It works to show month and day on a tab or in the list, I even can select them for sorting, but it has absolutly no effect, the list is shown in the order of database entries. :S

Thanks for any advice!!
Stefan

stackoverflow.com/questions/11213161/order-by-birthday-disregarding-year

Oh, thanks! Didn't know that I could use SQL-functions in ORDER-part of the SQL-statement :dry: :silly:

stefan.wulff wrote: Oh, thanks! Didn't know that I could use SQL-functions in ORDER-part of the SQL-statement :dry: :silly:

Yup, you can!

For completeness sake of this thread please post back complete solution for others reading.