Nice to start some discussion and sorry about the unclarity. Gulli, you are spot on with your code. Thanks!
Next challange is to get all the birthdays of the next 7 days. This code does *not *do the trick; > members_next = Member.query.filter( \ > (extract("MONTH", > Member.dateofbirth).between(today.month, nextdays.month) & \ > (extract("DAY", > Member.dateofbirth).between(today.day, nextdays.day) \ > ).all() > Because a birthday at 31-08 will not be between ( 30, 6). Any idea's? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.