counting where date < calculated date

[curiousfellow]

I have a dimension called yearsubcribe.

In a listbox I select a date (date_sel).

Now I want to count clients who subcribed before month and day of date selected .

It it possible that clients subcribe in year before year of subcription.(so daynumber of year won't work)

So I constructed this expression:

count ( distinct {< date_subcription ={"<=  date(date(date_sel,'DD')&'-' & date(date_sel,'MM')& '-' & text(yearsubcribe),'DD-MM-YYYY')"}>} clientid)

Is it not possible to use a dimension value in this expression or

do i make another mistake ?

[andrey_krylov · Accepted solution]

Try this

count ( distinct {< date_subcription ={"$(='<=' &  date(date(date_sel,'DD')&'-' & date(date_sel,'MM')& '-' & text(yearsubcribe),'DD-MM-YYYY'))"}>} clientid)

[curiousfellow]

Seems to work, Thnx

Is missed a bracket, but besides and went wrong with this piece ={"$(='<='

[andrey_krylov]

Just syntax error)