HubSpot Ideas

marcy730

Calculation Property Field Value in Reports

So we have this property built and on the record side, it shows year range. The property for us is an age calculation. It is taking the birth date and telling us how old the child is. When I pull this into a report I can only have it display how it does in the screen shot below. I would love it I could make it show years as well like it does on an actual contact record. 

 

Screen Shot 2023-02-01 at 12.11.54 PM.png

 

This is helpful because we are usually trying to build reports by an age range for classrooms we have spaces for. It looks weird with it showing 735 days or 820 days.

 

How it shows on an actual record: 

Screen Shot 2023-02-01 at 11.25.51 AM.png