Forum Discussion
mjsystemss
Resolver I
Resolver IRDL 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.
grazitti_sapna
Super User
Super User
v-aatheeque
Community Support
Community SupportHi 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.
mjsystemssThe 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.