2577292 - How to calculate age on a specific event date in Online Report Designer?

SAP Knowledge Base Article - Public

2577292 - How to calculate age on a specific event date in Online Report Designer?

Symptom

How to Calculate age on a specific event date in Online Report Designer

Environment

SuccessFactors

Online Report Designer

Reproducing the Issue

Given:

Date of birth

Event date

 

Find out:

Age on a specific event

Cause

The Date function needs to be configured via Calculated Column feature

Resolution

Please find below the steps to create a calculated column to calculate the age:

Select calculated column section

1.JPG

 

Select + sign to add a column:

2.JPG

 

Give a name to the column and click Edit.

Select:

Date Section > Global Job Information > Event Date

3.JPG

 

Select:

Date Section > Personal Information > Date of Birth

4.JPG

Select Token Editor (by double-click Event date and Date of Birth) >Function Selector >Select Year

5.JPG

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.

Keywords

Age on event Age Subtraction of dates for age , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Suite all versions