Custom Report by Contact Age

[Sam Boggiss]

Hi all,

I have a client who wishes to have a custom report of their CRM contacts which displays all of their contacts who are 65 years old or more. Each contact has their date of birth recorded, but filtering a custom report by date of birth means you need to edit the custom report every time you want to run it.

Does anyone know of a way to filter by [today's date] minus [date of birth]? Or another way of getting BC to calculate age from DOB?

Many thanks!

[Liam Dilley]

Hi there,

Not in the filter options of reporting currently.

It will be better to export the CSV to requirements that provide the CRM entries and then through Excel run a required macro/filter to sort or filter the data there.