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

    Date object creation based on Rowno()

    Jakub Szurogajlo



      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:




      What am I doing wrong in my 1st example?