10 Replies Latest reply: Mar 2, 2012 4:21 AM by jagan mohan rao appala RSS

    Date object creation based on Rowno()

    Jakub Szurogajlo

      Hello,

       

      Hope this problem is easy to solve. I've got a pivot table with months in first column,

      january in row 1, Feb in row 2 etc. I want to do calculastion based on it.

       

      I wrote some simple expression, but it return 0 in all columns:

       

      =Sum(IF(Date([Hire / Rehire Date]) < Date('1/'&rowno()&'/2011'),1,0)) 
      

       

       

       

      This on the other hand works fine

       

      Sum(IF(Date([Hire / Rehire Date]) < Date('1/1/2011'),1,0))
      

       

       

       

      When I tried checking date only it also works fine:

       

      =Date('1/'&rowno()&'/2011')
      

       


      What am I doing wrong in my 1st example?

       

      BR,

      Kuba