Filtering in Count

[#1]

Hi folks,

someone can help me on this sentence:

=count({$<AuditMonthYear={">=$(=Date(AddMonths(Today(),-1)), 'MMM-YYYY')))"}>} [Answer Mice])

I want to know what is wrong with that. I just want to know how many incidents we faced last month. I'm getting 0.

Thanks!

PS: The format date for both fields is MMM-YYYY so we got from both Jan-2012

[lironbaram]

hei

i think the problem your facing is that you try >=jan-2012 and it is not numeric

from my expirence the bets way is to have monthyear field who holds the month start date for every date in regular date format i.e 01/01/2012 that will work surley

[llauses243]

Hi adumd,

It this my offer, pls to see image attached

Good luck, Luis

[SunilChauhan]

try this

count({<AuditMonthYear={">=$(=Date(addmonths(today(),-1),'MMM-YYYY'))"}>} [Answer Mice])

AuditMonthYear should be in MMM-YYYY format.

hope this helps

[#5]

try to implement this:

count({$<AuditMonthYear>={"$(=(Date(AddMonths(Today(),-1)), 'MMM-YYYY'))"}>}[Answer Mice]).

[#6]

Thanks Sunil,

considering differents answers received, your is most close to the final result. Nevertheless the result is not quite correct. I'm getting 57 instead 51 (which is the correct number). Maybe you can explain to me how the ={">=$(=Date(addmonths(today(),-1),'MMM-YYYY'))"}>} works. I think I got some idea, but just want to be sure.

Thanks in advance!