2162424 - Ad Hoc report result is not as expected when using Date Filter rule selection Less than or Equal to and the Free Text

SAP Knowledge Base Article - Public

2162424 - Ad Hoc report result is not as expected when using Date Filter rule selection Less than or Equal to and the Free Text

Symptom

You have created an Ad Hoc report with a filter rule, which involve Less than or Equal to, type the date manually and notice that the records shown stop to the day before the date you have entered.

For Example, you give Form End Date "Less Than Or Equal To" 12/17/2010 and generate the report but you notice that the records displayed stop to the day before the selected value e.g. 12/16/2010.

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Reports

Reproducing the Issue

  1. Login to the instance
  2. Select Reporting > Analytics > Ad Hoc Reports
  3. Create an Ad Hoc report
  4. For this example, create a filter rule as below:
  5. Form End Date Less Than Or Equal To 12/17/2010 where the date 12/17/2010 is entered manually rather than selected from the drop down list.
  6. Generate the report
  7. The report will give data up to 12/16/2010 for this column.

Cause

The current report behaviour is as designed although we are looking for ways to improve such functionality.

Resolution

The reason you don’t see the record that happened during the day of the selected date is because when filtering on a date field, it is actually filtering on date + time.

Using the example in this article: "Suppose if we give Form End Date "Less Than Or Equal To" 12/17/2010 and generate the report. It will give data up to "12/16/2010""

The reason for such behaviour is that the actual filter is on date + time, e.g. "12/17/2010 00:00:00"; Therefore records that have happened during the day of the 12/17 will not appear.

As a workaround to get results for the full day you can select the day after the last date e.g. in this case "12/18/2010" as this will be "12/18/2010 00:00:00".

Keywords

Adhoc date filter, ad hoc date filter, date timestamp , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Core all versions