Date Selections-Issue

[#1]

I need help on this :

I have four years: 2013,2012,2011,2010 and the Month columns for each.

If i click on the year 2013 and Month Jan, i should get the count of UserIds for all the months starting from Jan -1 -2010 - Jan-31- 2013.

I am trying to use the below expression .But I am not getting the desired output.MnthEndDate here for Jan will be : 2013-01-31

=Count({$ <JOIN_DATE={'<=$((MnthEndDate))'}, ACTIVE={1}, DateType = {'MEMBERS'} >} DISTINCT UserID)

Is the expression correct?

[Gysbert_Wassenaar]

This should work as long as the variable MnthEndDate is a date and not just a string value and has the same date format as JOIN_DATE.
=Count({$ <JOIN_DATE={'<=$(MnthEndDate)'}, ACTIVE={1}, DateType = {'MEMBERS'} >} DISTINCT UserID)

JOIN_DATE should of course be a date too and not a string value.

[#3]

I am not getting the desired output with the above expression

[vikasmahajan · Accepted solution]

That means your transactions are not linked to master calender , Please  implement master calender in your application.

As  G Wassenaar Suggested this should works.

Vikas

[#5]

Hey Tks man!

it worked !!