Help with set expression

[#1]

Looking to count the distinct users where month is less than or equaly to april 2014. When I apply the formula it returns a 0. Can anyone suggest what I am doing wrong here?

Count(Distinct{<Month={"<={'Apr'}"}>}Event.User)

[venkatg6759]

Try to use Num# function before month and try

[#3]

can you give an example please? syntax is everything

[its_anandrjs]

Try one of this ways and add a NumMonth field in the model like and then use that field in your expression see the expression below.

Load

Num(Month(DateField)) as NumMonth

From Location;

=Count(Distinct{<NumMonth = { "<=$(=Num(Month(AddMonths(Today(),-2))))"  }>}Event.User)