4 Replies Latest reply: Nov 23, 2011 2:30 PM by Herman Cox RSS

    Transact-SQL to QlikView code

      Hi all there,

       

      I'm a fairly new guy here in the QlikView community,

      I'm having some difficulties putting a Transact SQL statement into QlikView.

       

      Can someone give me an Idea in the right direction?

       

       

      Statement:

       

      CASE DUEBYTIME WHEN 0 THEN NULL

      ELSE dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (DUEBYTIME / 1000), '1970-01-01 00:00:00') END AS Verval_Datum

       

       

      Thanks in advance.