Home Forums Reporting Services Reporting Services 2005 Development Error when previewing a report with date parameters 'Conversion failed when converting datetime from character string' RE: Error when previewing a report with date parameters 'Conversion failed when converting datetime from character string'

  • June 2, 2010 at 4:28 am

    #1175188

    Then thers is possibly data in that column that is not a true datetime and SQL will not be able to implicity convert this to a valid datetime.

    Run a select on the table using ISDATE to find out what the offending data is.