Difference between revisions of "Field Values in Expressions"

Revision as of 00:43, 18 October 2011

The search value - a string, a date, a number.

Follow these guidelines when specifying values:

The value can be partial text or whole words
Enclose strings and date/time values in 'single quotes'
To specify date values, use the Date Format as specified in Company Information
To search for a blank (empty) string, use two single quotes, with nothing between them ('').
To search for a blank (empty) field of other kinds, use a field value of BLANK
To include multiple values for a field, separate each value using the pipe symbol (|)
To include a single quote in the value, specify four single quotes ('''').

For example, to search for the phrase, That's right! you would specify 'That''''s right!'.

Examples:

String: 'Paper 123'

Date: '06/06/2007'

Numeric Value: 9383

Empty Field: '' or BLANK

Revision as of 20:24, 10 June 2011 (view source) imported>Aeric m (moved Field Value in Expressions to Field Values in Expressions) ← Older edit		Revision as of 00:43, 18 October 2011 (view source) imported>Aeric Newer edit →
Line 1:		Line 1:
	~~;<tt>~~FIELD_VALUE~~</tt>:~~		====FIELD_VALUE====
	:The search value - a string, a date, a number.		:The search value - a string, a date, a number.