6 Replies Latest reply: Sep 5, 2016 2:35 PM by Roland Bouman RSS

    Wrong output of Week()

    Roland Bouman

      Hi all,

       

      The output of Week() function seems to be wrong, while output of Today(2) and WeekStart(Today(2)) is right. The current week number of today (5th of September 2016) should be 36, but the output of Week() is 37 instead. I've checked system and QlikView server date/time and these are fine.

       

      It doesn't matter on which day I test this, the week number is always 1 too much. I've attached QlikView's output. Of course it's easy to get around this by using Week(Today(2)-1), but that shouldn't be necessary.

       

      Has anyone came across this issue? Any help is highly appreciated.

       

      Best regards,

      Roland Bouman