6 Replies Latest reply: Jul 30, 2012 11:16 AM by adam justyn RSS

    How to get proper date value from a number?

      Dear All,

      I'm new to QlikView.

      I have got my data in MS SQL database.

      The DateX column is stored as the number of days since 28/12/1800.

      To questions:

      1. How to get to the proper date value in QlikView for a number 77070 (I know it should be 01/01/2012.

      2. Is it possible to use in QlikView script MS SQL Scalar-valued function which does the conversion to proper date. (Function takes the DateX column as an argument  and returns varchar(10) string).

       

      Thanks in advance for your contribution.

      Regards

      Adam