it seems not to work.
my table field is called AGE and is a datefield "1972-04-13" for example.
in my recordset, i get this datefield and make it to show only the year.
there for I use this MySQL function:
(YEAR(CURRENT_DATE) - YEAR(profile.age)) - (RIGHT(CURRENT_DATE,5) < RIGHT(profile.age,5)) AS age
it seems that it does not compare my search form field (minimum) with that SELECT.