SAP Knowledge Base Article - Preview

2766315 - Adhoc Report produces blank results when selecting the date of 12/31/9999 in the runtime filter for maximum date range

Symptom

  • Adhoc report will produce blank results (thru Run Online) while setting the maximum date range of 12/31/9999 in the runtime filter
  • Run the adhoc report offline (thru excel) and the file will produce the error 

Error encountered in executing the query.[303]: invalid DATE, TIME or TIMESTAMP value: year must be between -4713 and +9999, and not be 0: 10000: type_code=14, index=2


Read more...

Environment

SAP Success Factors Workforce Analytics (ANA) - All versions

Product

SAP SuccessFactors HCM Suite all versions

Keywords

12/31/9999, adhoc runtime filter, date filter, open end date , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

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.