Hello to all
I just followed the “Calculating age from Date of birth” tutorial and works perfect. My question is, Can I only show in the table the persons that are over 26 years old?
Yes, you can do that easily. I am on my phone right now so can’t show a screenshot but you would do that in your server connect query.
datevalue < Now() -26 years is the logic. When I get to a computer I will show actual screenshots if you haven’t got it figured out.
Yes, I will need that screenshot when you have time please
Thanks in advance
In your query add a condition based on your birthdate field.
Edit: Should be ‘-26’ in the formatter not ‘26’
is not working, when I apply the condition, doesn’t show any data
“Less or equal”, not “equal”
If you use “equal” you’re only selecting users with exactly 26 years old - worse, 26 years old and exactly x seconds, that’s why you’re not getting any data
1 Like
Yes, Apple is correct. You need Less Than and Equal not just Equal.
Hello, I use grater than and show me all the records, with less than is not showing anything. I think my problem should be with the data may be