Hello to all,
I have a table that I have the DOB of all the people already, I need to make the table show from 26 years old and olders only. Can someone help please.
You should be able to use the formatter in your query.
Date field value is =< Now() add years -26years. On my phone right now so can’t provide a screenshot. But hopefully that will get you in the right direction.
Thanks, I will try it. But I have the DOB only, I need to convert it to age in number first?
Post here your database schema’s DOB field, and a DOB example, because there are multiple ways a date of birth can be represented or stored
Assuming you are storing the dates in a date field/format. You don’t need to convert anything. Just the date is good. 
1 Like