Comparison operators

Text

Equal to

Not equal to

Contains

Does not contain

Starts with

Does not start with

Any text string

Matches

Does not match

A regular expression

Boolean

True

False

None

Integer Rational

Equal to

Not equal to

Less than

Less than or equal

Greater than

Greater than or equal

A decimal integer or floating point number, example, "-12" or "0.56"

A constant expression using + - * / operators; example:

• 5 * 1024 * 1024

• 2/3

• 6.77 + 8.55

Date

Equal to

Not equal to

Earlier than

Earlier than or same

Later than

Later than or same

An ISO 8601 formatted date/time (equivalent to format string "yyyy-MM-ddThh:mm:ss.zzz") or any portion thereof

Enter a format string in the Format argument of the variable to specify which portion of the date and/or time should take part in the comparison

For example, you may enter "yyyy-MM" for the format string and "2007-08" as the comparison value to compare year and month