Forum Discussion

mjsystemss's avatar
mjsystemss
Resolver I
4 months ago
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...
200
error
  • mjsystemss's avatar
    mjsystemss
    3 months ago

    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.

cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

Replace CAST with TO_DATE on Grant_Execution_Date:

TO_DATE(
    TO_CHAR( Grant_Execution_Date ),
    'MM/DD/YYYY'
    DEFAULT NULL ON CONVERSION ERROR
) AS Grant_Execution_Date