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.

Reply via email to