Expressions - Data Types


Each variable in an expression has a value which may be one of the following types:

String

Values of type string are text values. When specifying a string in an expression the string must be enclosed in double quotes.

Integer

Values of type Integer are numeric values. Only whole numbers can be used and these must lie in the range -2,147,483,648 to +2,147,483,647.

Float

Values of type Float are numeric values. There are no practical limits to the size of number a Float value can hold.

Boolean

Values of type Boolean can only take one of two values, True or False. They are logical values and every criteria and filter expression should result in a Boolean value.

Date

Values of type Date contain both date and time information. A number of formats for specifying date values are available including short and long forms such as '25/2/06 16:30' and '25 February 2006 4:30pm'. When specifying a date in an expression the date must be enclosed in single quotes.

StringList

Values of type StringList contain zero or more strings, grouped together in a collection.