AnsweredAssumed Answered

Text if a record falls between two numbers

Question asked by JacksonGallagher on Feb 14, 2012
Latest reply on Feb 14, 2012 by philmodjunk

Title

Text if a record falls between two numbers

Post

I'm trying to write a script that takes a variable (passes as a script parameter) we'll call this $number. I then want to compare it to $low and $high. If $number is not between these two I want to omit the record and only be left records where $number is between $low and $high. I am trying:

 

if($low < $number AND $number < $high)

Go to next record

else

omit record

endif

 

Is this the proper way or am I missing something? Either way, it is not working.

Any help is greatly appreciated.

Screen_Shot_2012-02-14_at_10.16.04_AM.png

Outcomes