Create a calculated field for Age Create a calculated filed using the calculation below: (Replace the [Birth Date] with the date of birth column from your datasource) IF DATEADD('year', DATEDIFF('year', [Birth Date], TODAY()), [Birth Date])> TODAY() THEN DATEDIFF('year', [Birth Date], TODAY())-1 ELSE DATEDIFF('year', [Birth Date], TODAY()) END