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.