Selection of data

[#1]

Hello

i need help with selecting data.

I need data  from field AcAm filtered by AcNo >=3000 <=3999 AND ValDT <= variableDate

I tryed this, but i seams that the variable not work.

sum( {$<AcNo= {'>=3000<=3999'},ValDT= {'<=$(vMyLastDateOg Month_N)'}>} AcAm)

Is it something wrong with tis expression?

//Gunnar

[giakoum]

Actually it looks ok.Try replacing the single quotes with double quotes. Otherwise please post same sample report,

Did you check that the variable is in the correct date format? Try with a fixed value first.

[kumarnatarajan]

Hi,

Check the your variable format and  ValDT format

And Remove the (vMyLastDateOg Month_N) variable space.

[shree909 · Accepted solution]

Hi,

The expression looks good  but u need to find out the value of this variable   $(vMyLastDateOg Month_N) if its mathing with the  ValDT  or r eplace thevariable with the value and try it , the varaible value should exactly match with the ValDT values then only the expression works

or Try this 
sum( {$<AcNo= {'>=3000<=3999'},ValDT= {'<=$(=vMyLastDateOg Month_N)'}>} AcAm)

[#5]

I found the problem. I have wrote ValDT as a field name, it should be ValDt.

I was not aware that it had to be the case senitive

Tank'f for the hint

//Gunnar