20 Replies Latest reply: Oct 26, 2014 6:28 PM by Acatoy Andres RSS

    Date Conversion Problem

    khasimvali shaik

      Hi Community,

       

      Can any body solve this Error when i connect to data base Table showing error like

       

      ''ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Conversion failed when converting date and/or time from character string.''

       

      I Change Given format below

       

      ,Convert(Varchar,[Date_Field],103) as Date_Field   is it right?

       

       

      Thanks in Advance

      Regards,

      Khasim.