Date selection and Count expression not evaluating properly

[#1]

Hello

Expression in chart: Count({<Doc_Date = {'>=$(vStartDate)<=$(vEndDate)'}>} {< ID = {">=$(vMaxID)"}>} EQUNR_S)

Selected Start Date 01.04.2014 and End Date 31.04.2014 but it's not evaluating properly also records are not filtered properly.

Count is coming wrong.

Act_Typ	EQUNR_S	ID	Doc_Date	Count
E	17603	3827	01.02.2011	1
T	17603	29198	15.04.2013	1
F	17603	29194	15.04.2013	1
D	17603	29196	15.04.2013	1

Ashif

[alexandros17]

Sysntax is not correct ...

try this

Count({<Doc_Date = {'>=$(vStartDate)<=$(vEndDate)'}>}, ID = {'>=$(vMaxID)'}>} EQUNR_S)

[#3]

I think synstax is right. Expression not evaluating.

[kuba_michalik · Accepted solution]

Proper syntax is

Count({<Doc_Date = {">=$(vStartDate)<=$(vEndDate)"}, ID = {">=$(vMaxID)"}>}  EQUNR_S)

Searches in set analysis go in double quotes. They might work with single quotes but it's a bug (single quotes should only be used for string literals) and taking advantage of it is not advisable.

If that doesn't work, then the likely reason is what the vStartDate, vEndDate and vMaxID variables are actually expanding to.

Are the numbers you posted a sample of the data, or how the table with this expression looks?