How to Calculate age on a specific event date in Online Report Designer
Online Report Designer
Reproducing the Issue
Date of birth
Age on a specific event
The Date function needs to be configured via Calculated Column feature
Please find below the steps to create a calculated column to calculate the age:
Select calculated column section
Select + sign to add a column:
Give a name to the column and click Edit.
Date Section > Global Job Information > Event Date
Date Section > Personal Information > Date of Birth
Select Token Editor (by double-click Event date and Date of Birth) >Function Selector >Select Year
Click Ok >Ok>Done
Find the last column in the query and it will show the age(in years) of the user on the specific event.
Age on event Age Subtraction of dates for age , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To