200
1 Topic
RDL Error
Hello, I have been getting this error on rdl file since today. I have tried to format the date columns SELECT TO_DATE(App_Submitted_DT DEFAULT NULL ON CONVERSION ERROR, 'MM/DD/YYYY') AS App_Submitted_DT, TO_DATE(Curr_Application_Status_DT DEFAULT NULL ON CONVERSION ERROR, 'MM/DD/YYYY') AS Curr_Application_Status_DT, CAST(Grant_Execution_Date AS DATE) AS Grant_Execution_Date FROM YOUR_TABLE_NAME yet the problem persists. I need some advise on what to do. ERROR ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ---------------------------- Cannot read the next data row for the dataset 'EVMS_Detail_Tab'. ---------------------------- An error has occurred during report processing. ---------------------------- An error occurred during local report processing.Solved1.5KViews0likes10Comments