SAP Knowledge Base Article - Preview

2950490 - Unexpected result with Calculated date columns to pull yesterday or tomorrow records - Advanced Reporting

Symptom

A calculated column in Advanced Reporting is supposed to show the number of the difference between dates e.g. Last Modified Date and Today (dynamic date). However, the result is not showing the expected number. For example, Last Modified Date is 07/19/2020 and Today is 07/21/2020:

Calculation: [Last Modified Date] - [TODAY]

The expected result is -2, because the calculation is [07/19/2020] - [07/21/2020], but the report is showing -1.


Read more...

Environment

SAP SuccessFactors HCM Suite

Product

SAP SuccessFactors HCM Suite all versions

Keywords

calculated column report Advanced Reporting date number difference dates tomorrow today calculation , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.