Reputation: 88
What's the least painful way to filter a least of people by their age
e.g. only show people over the age of 60 based on their birthday
Upvotes: 0
Views: 345
Reputation: 1471
Use a Content Query web part.
Assuming a Date field called DOB, add the content query web part to a page and edit the web part. Expand the query section and add your list to Show items from the following list
.
Then under Additional Filters
> Show items when:
select DOB
field and is less than or equal to
and in Custom Value or Query
enter -21915 then click Ok and the web part should show people over the age of 60.
Upvotes: 1