Forum Discussion
Solved
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_Submit...
This has been resolved. SSRS has date range it can handle. As a column contains date and days. Dates outside 100 years bound will give an error.
Hi mjsystemss
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.
The problem was the date range ssrs can handle. So any date or days more than 100 years gives an error. The column is a projected date column.