what does DA search, the field itself or the field after the recordset?
cause one of my fields ist just a date 1972-04-13 but the recordset transforms it to the age in years. 38
(YEAR(CURRENT_DATE) - YEAR(profile.age)) - (RIGHT(CURRENT_DATE,5) < RIGHT(profile.age,5)) AS age
will it compare to 38 or DATE?