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:19 am

    #1175185

    I have tried the convert function (to datetime) but then get an 'arithmetic overflow error converting expression to data type datetime'.

    I have also amended the view to reference a different column which already has a data type of DateTime but still no joy (I get a similar error regarding 'conversion to int').

    Thanks

    N.