3 Replies Latest reply: Dec 2, 2015 4:49 AM by Matthias Oehme RSS

    NPrinting Pixel Perfect: Convert Qlikview Datetime format to Dayname()

    Matthias Oehme

      Hello community,

       

      in a pixel perfect report I would like to display the min and max Date of the selected values. I added the formula

       

      =dayname(max(DateTime))

       

      and the result preview shows me the corresponding date (i.e. '31.10.2015'). But when I use the field [maxDate] in the Report it displays me the Date in the numerical qlikview format, i.e. 42307.

       

      I already tried several ways with formatting the label as DateTime, with no luck. (it returns 'dd42307MMyyyy') and in the NPrinting Training I wasn't able to finde an example.

       

      Before I made some Word /Excel Reports, there was no problem in displaying the values as intended.

       

      I hope someone can help me out.

       

      Kind Regards

       

      Matthias