Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
3 months ago
I was asked to create a report showing contacts and one of the filters requested is only contacts who are over 40 years old. The contacts have a Birthdate field.
In the report filter, I can't figure out how to set this criteria. Should I use a relative date? I've tried using the date 40 years from now but I realize this won't be valid in a year's time, for example.
6,889 23 23 gold badges 27 27 silver badges 34 34 bronze badges
You may want to do some date math where you can do something like:
YEAR(Contact.Birthdate) <= YEAR(TODAY())-40
This is purely going to be based off year and not the actual month day, but this will get you close
Feb 15 at 18:22
Bryan Anderson Bryan Anderson
2,356 12 12 silver badges 13 13 bronze badges
log in to answer this question.
Not the answer you're looking for? Browse other questions tagged
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only