Birthday element, filter by age range

[pakeydev]

Hi,

Need help on how to filter age by range.
Using the birthday element and filter it by age 40-45, age 45-50, age 50-55, etc...

Is it possible to do this?


Thanks for any help

 

[lousyfool]

I'd probably try a extra calc element hidden in the form, where the age range is calculated always "on the fly", then filter on this.

 

[troester]

The problem with calc elements: Those "on the fly" calculations needed for dates etc. are not stored in the database and list filters are looking for database values.
Do you need to filter? Or is "group by" (on such a calc element) a possibility?

For filtering I could imagine a custom list template with dynamicly calculated links/buttons with URL filtering.
Or (if it's on a readonly list) a MySQL view.
Or calculate and store this filter element on list load (php-events).

 

[lousyfool]

The problem with calc elements: Those "on the fly" calculations needed for dates etc. are not stored in the database and list filters are looking for database values.

Ooooohhh right...