2 Replies Latest reply on Mar 1, 2016 10:50 AM by Nirupam Haas Tirukkovalluri

    Date Calculation returns null after data extract in SQL Server

    Nirupam Haas Tirukkovalluri

      In SQL Server DB my date calculated field returns null values after data extract

       

      Below is the formula for date calculated field

       

      DATETIME(STR([Date]) + " "

      + STR(DATEPART('hour',[Time]))+ ":"

      + STR(DATEPART('minute',[Time]))+ ":"

      + STR(DATEPART('second',[Time])))

       

      Thanks

      Nirupam