4 Replies Latest reply: Apr 2, 2014 2:23 PM by Stefan Wühl RSS

    Is there A known bug on the WEEK() function?

    Shaul Sondak

      QV_Ver.PNG.png

      In a Text Object expression:

      = 'Week(MakeDate(2000,1))=' & Week(MakeDate(2000,1)) & Chr(10)

      & 'Week(MakeDate(2001,1))=' & Week(MakeDate(2001,1)) & Chr(10)

      & 'Week(MakeDate(2002,1))=' & Week(MakeDate(2002,1)) & Chr(10)

      & 'Week(MakeDate(2003,1))=' & Week(MakeDate(2003,1)) & Chr(10)

      & 'Week(MakeDate(2004,1))=' & Week(MakeDate(2004,1)) & Chr(10)

      & 'Week(MakeDate(2005,1))=' & Week(MakeDate(2005,1)) & Chr(10)

      & 'Week(MakeDate(2006,1))=' & Week(MakeDate(2006,1)) & Chr(10)

      & 'Week(MakeDate(2007,1))=' & Week(MakeDate(2007,1)) & Chr(10)

      & 'Week(MakeDate(2008,1))=' & Week(MakeDate(2008,1)) & Chr(10)

      & 'Week(MakeDate(2009,1))=' & Week(MakeDate(2009,1)) & Chr(10)

      & 'Week(MakeDate(2010,1))=' & Week(MakeDate(2010,1)) & Chr(10)

      & 'Week(MakeDate(2011,1))=' & Week(MakeDate(2011,1)) & Chr(10)

      & 'Week(MakeDate(2012,1))=' & Week(MakeDate(2012,1)) & Chr(10)

      & 'Week(MakeDate(2013,1))=' & Week(MakeDate(2013,1)) & Chr(10)

      & 'Week(MakeDate(2014,1))=' & Week(MakeDate(2014,1)) & Chr(10)

      & 'Week(MakeDate(2015,1))=' & Week(MakeDate(2015,1)) & Chr(10)

      & 'Week(MakeDate(2016,1))=' & Week(MakeDate(2016,1)) & Chr(10)

      & 'Week(MakeDate(2017,1))=' & Week(MakeDate(2017,1)) & Chr(10)

      & 'Week(MakeDate(2018,1))=' & Week(MakeDate(2018,1)) & Chr(10)

      & 'Week(MakeDate(2019,1))=' & Week(MakeDate(2019,1)) & Chr(10)

       

      Results:

      QV_Ver.PNG.png