VA FileMan V. 22.0 Getting Started HTML Manual Banner

 

Contents: Main Chapter See Also: Getting Started Manual Programmer Manual

VA FileMan Functions

BETWEEN

Format: BETWEEN(n1,n2,n3)
Parameters:

n1, n2, and n3 are numbers or numeric expressions:

  • n1 is the number being tested.

  • n2 is one limit for the test.

  • n3 is the other limit for the test.
Use: This Boolean function determines if n1 is within the limits defined by n2 and n3. If n1 is within this range, a value of 1 (true) is returned; otherwise, 0 (false) is returned. If n1 equals n2 or n3, 1 (true) is returned.
Examples:

BETWEEN(OCCURRENCES,5,10)=> 0 [OCCURRENCES is a field with value=3]

BETWEEN(-3,-10,0)=> 1

 

Reviewed/Updated: March 4, 2007