2 Replies Latest reply: Apr 17, 2012 12:11 PM by Celambarasan Adhimulam RSS

    What datatype to make calculation?

      Goal:

      Display the value in hours by calculating end - begin.

       

      Problem

       

      I have table with data

       

       

      BeginEnd
      2011-11-10 12:12:122011-11-12 12:12:12
      2011-11-10 12:12:122011-11-11 08:12:12

       

      I need help with following issue:
      *What datatype do I need to use in order calculate? I need a similiar datatype as datatime from SQL server. It doesn't work to use QlikView's datatype date to make a calculation

       

      // JJ