Select in Field Trigger Greater than less than not handling exceptions

[#1]

Hi,

I have input box, which has 2 inputs vMinSY and vMaxSY for user to enter a value and I have triggers set on these variables to select in field "X" and have the expression ='>='&$(vMinSY)&'<='&$(vMaxSY) in Search String. If I input something like vMinSY = 20 and vMaxSY= 30, I get the values in field "X" which are >= 20 and <=30, but if I enter vMinSY=30 and vMaxSY=20, I get values of field "X" less than or equal to 20, but I don't want the field "X" to return anything, if vMinSY > vMaxSY.

Thanks!

[#2]

Thanks, it works!

[#3]

Thanks, it works!

[Digvijay_Singh]

Hi Sunny,

Can you help me to understand why expression ='>='&$(vMinSY)&'<='&$(vMaxSY) is not working for me but for all of you guys. It works with  apostrophe around $(vMinSY) and $(vMaxSY) , like ='>='&'$(vMinSY)'&'<='&'$(vMaxSY)'.

Thanks in advance!

[sunny_talwar]

Can you share the test file where you are testing this...

[Digvijay_Singh]

Here it is,  I was trying trigger with Year field. When I remove apostrophe around $(), it doesn't respond. Checked 2-3 times.

[sunny_talwar]

Should work now... your vMinSY variable had an extra space

[Digvijay_Singh]

Thanks! You are great!