3 Replies Latest reply: Apr 28, 2016 12:21 PM by Gysbert Wassenaar RSS

    Calendar Variable

    Ziad Salem

      Hi!


      I have a problem with Calendar Variable which it is an extension from Qlik Branch (Qlik Branch). the date format is DD/MM/YYYY, and in my project I need to add the time (
      DD/MM/YYYY hh:mm:ss).

      How can I do that? moreover, In some queries I need a fixed time I mean for example the From Date: (DD/MM/YYYY 00:00:00)
      and and for the To Date (
      DD/MM/YYYY 23:59:59). I tried to add the time (00:00:00) in a new variable but the problem the date converted to a number and the value appear like [for example ] (00994568415 00:00:00). Please see the attached pic for more explanation.

      Thanks.

       

      4.png