CiviCRM Community Forums (archive)

hey folks,

i have a group that needs to regularly look at a subsection of their members who are 65 and over. i thought a smart group would be useful, since age changes every day but cannot see how to accomplish it.

i tried to do a custom search but only have Birthdate available and there does not seem to be a way to get it to look up the age of the person based on a variable like *today*

any thoughts on how to do this?

thanks!

thanks for the reply lobo. when you say "build a custom search" are you referring to the Search Builder? if so, how do i take in age as a parameter?

then you say "use sql date functions to grab all the contacts from the db who are older than 65." where would i do that? also in Search Builder?

trying to understand how this all fits together.

thanks!

Hi,

For performance reason, I'd suggest to first calculate today's date, add 65 and use it as a constant in the sql. My experience with using date functions within sql is that it doesn't use indexes anymore most of the times.

X+