2268311 - ORD - how to create a column to produce the difference in dates in years as a decimal

SAP Knowledge Base Article - Public

2268311 - ORD - how to create a column to produce the difference in dates in years as a decimal

Symptom

ORD - how to create a column to produce the difference in dates resulting in years as a decimal.

Currently if a calculated column is created with the formula DateX minus DateY, the difference will be displayed in number of days. See eg. below for Time In Position, this will result in the number of days displayed in the calculated column.

KB - calculated column date difference 1.png

 

 

 

 

 

 

 

 

Resolution

Create calculated column with the difference in dates formula to get the number of days difference between two dates. Make sure that there is no function parameter set as cicled below.

KB - calculated column date difference 2.png

Create a second calculated column with a number data type. Select the previous calculated column (in e.g. above this would be Time in Position) and divide by 365 to give the result in years. Also, edit the number format to reveal more decimal places if required (more accurate).

KB - calculated column date difference 3.png

 

 

Keywords

KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors Workforce Analytics all versions