Selecting the Data Type

The data type defines the type of value that replaces the input and output parameters in your formula.

You can select from the following data types:

• Text: A sequence of characters without double-quotes. See formatting details

  Example: The formula "SEARCH("a", %(text))" produces "2" when the word Laserfiche is entered in the token, where "%(text)" is of the data type "Text". When "%(text)" is of the data type "Integer", the formula produces an error.

• Integer:  A large positive or negative number without a decimal between -2^31 and (2^31) - 1. See formatting details

  Example: The formula "ABS(%(integer))" produces "3" when the value -3 is entered in the token, where "%(integer)" is of the data type "Integer". When "%(integer)" is of the data type "Text", the formula produces an error.

• Long: An even larger positive or negative number without a decimal between -2^63 and (2^63) - 1. See formatting details

  Example: The formula "ABS(%(integer))" produces "3" when the value -3 is entered in the token, where "%(long)" is of the data type "Long". When "%(long)" is of the data type "Text", the formula produces an error.

• Decimal: A positive or negative number that can contain a decimal. See formatting details

  Example: The formula "ABS(%(decimal))" produces "3.32" when the value -3.32 is entered in the token, where "%(decimal)" is of the data type "Decimal". When "%(decimal)" is of the data type "Text", the formula produces an error.

• DateType: A date value (with or without a time value). See formatting details

  Example: The formula "DAY(%(date))" produces "20" when the value 2018-06-20 is entered in the token, where "%(date)" is of the data type "Date". When "%(date)" is of the data type "Text", the formula produces an error.

  DateTypes may be formatted as follows:

  Date Formats

  Format	Example
  YYYY-MM-DD	2018-06-20
  YYYY/MM/DD	2018/06/20
  YYYY-MM-DD	2018-06-20

• Boolean: An either-or relationship. See formatting details

  Example: The formula "!%(boolean)" produces "false" when the value true is entered in the token, where "%(boolean)" is of the data type "Boolean". When "%(boolean)" is of the data type "Text", the formula produces an error.