Skip to Content
Technical Articles

How to use dates in formulas in Compensation worksheets

Overview

Formulas using dates can be difficult to implement in SuccessFactors Compensation templates due to the complexity of the formula parameter.

Additionally some Employee Central fields such as Age (but also Compa-Ratio or Range Penetration and a significant number of other fields) cannot be retrieved directly from EC into a column of a compensation worksheet because they are Transient fields, which means they are calculated on the fly in EC and their data isn’t stored.

 

Solution 

In this 3 minutes recording we go through the steps required to build a formula that recalculates the age of an employee in a compensation worksheet using the dateDiff function.

Please find more Q&A on dateDiff formulas on the SAP blog question thread here.

1 Comment
You must be Logged on to comment or reply to a post.