Free cookie consent management tool by TermsFeed

a!isBetween Function

On This Page

Function

a!isBetween( value, upperLimit, lowerLimit ) This function is frequently used in validations.

Checks if a value is within the specified range. The value can be of type date, date and time, number integer, or number decimal.

See also: applyValidations()

Parameters

Keyword Type Description

value

Any Type

The value that is checked to determine if it is in the specified range.

upperLimit

Any Type

The highest value in the range.

lowerLimit

Any Type

The lowest value in the range.

Returns

Boolean

Examples

Copy and paste an example into an Expression Editor to experiment with it.

This expression returns true because 4 is between 1 and 6.

1
2
3
4
5

a!isBetween(
  value: 4,
  lowerLimit: 1,
  upperLimit: 6
)

This expression returns false because the lowerLimit and upperLimit values are not included in the evaluation (that is, the range excludes the lower and upper limits).

1
2
3
4
5

a!isBetween(
  value: 4,
  lowerLimit: 4,
  upperLimit: 6
)

This expression also returns false because the upperLimit date is excluded from the comparison.

1
2
3
4
5

a!isBetween(
  value: todate("07/26/2025"),
  upperLimit: todate("07/26/2025"),
  lowerLimit: todate("07/24/2025")
)

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Partially compatible

Can be used with Appian Portals if it is connected using an integration and web API.
Offline Interfaces Partially compatible

Can be used with offline interfaces if loaded at the top of the interface.
Sync-Time Custom Record Fields Incompatible
Real-Time Custom Record Fields Incompatible

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports Incompatible

Cannot be used to configure a process report.
Process Events Partially compatible

If autoscale is enabled, can be used to configure a supported process event node (such as a start event or timer event).
Process Autoscaling Compatible

Can be used in autoscaled processes.
Event Consumer Filter Conditions Compatible

Can be used in filter conditions.
Event Consumer Event Handlers Compatible

Can be used in event handler expressions.

Feedback