[SOLVED] Filter on relative age in lists?

I've lost all my filters and list formatting with the 2.0 upgrade, so I need to make a filter for my list that shows people below 18 years. I can't remember how I did it before.
I have their birthday (of course) in the profile, but how do I construct a filter that does that?

Advanced filter or basic filter? There was a problem with advanced filter migration, which we've fixed in latest CB 2.0 nightly. If you've a backup you can restore to the backup then install the nightly so it can remigrate. I've no idea what your filter was either so I don't know what to suggest, sorry.

A lot of stuff is updated since the move to 2.0, but I found an old backup, and looked in the advanced filters for those lists.
It had a filter like this:
( ( YEAR( NOW() ) - YEAR( ue.`cb_birthday` ) ) < 19 )
To show people 18 year old or younger, and that filter worked in the 2.0 as well.

fribse2011 wrote: A lot of stuff is updated since the move to 2.0, but I found an old backup, and looked in the advanced filters for those lists.
It had a filter like this:
( ( YEAR( NOW() ) - YEAR( ue.`cb_birthday` ) ) < 19 )
To show people 18 year old or younger, and that filter worked in the 2.0 as well.

We have just released CB 2.0.1 that does address various issues identified with migrating user lists from CB 1.9.1 upgrades.

fribse2011 wrote: A lot of stuff is updated since the move to 2.0, but I found an old backup, and looked in the advanced filters for those lists.
It had a filter like this:
( ( YEAR( NOW() ) - YEAR( ue.`cb_birthday` ) ) < 19 )
To show people 18 year old or younger, and that filter worked in the 2.0 as well.

Yup, that was broken in 2.0, but it's fixed in 2.0.1. You can restore to the backup then install 2.0.1 to redo the migration or you can just add your filter back in to your userlist manually.

And it works as it should, thankyou!