Date object creation based on Rowno()

[#1]

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

[jagan]

Hi,

"Month" is your Month field name in you file.

Regards,

Jagan.