U.M. (Mac OS)

Creating a database file 2-15
Expressions
An expression is a value or any computation that produces a value.
Expressions can be combined to produce other expressions.
Constants
A constant is a fixed value that’s part of the formula and doesn’t change
from record to record. A constant can be text, or a number, date, or time,
like the text value “Europe” or the numeric value 0.05.
FileMaker Pro interprets the type of data of a constant value according
to the way you type the constant in a formula. Be sure to type each
constant in a consistent format. (Quotation marks indicate a text
expression.)
Type of expression Example
Text constant "London"
Number constant 2.15
Field reference TaxRate
Function Length(ShipToAddress)
Combination of expressions ((Total–Discount)*TaxRate)/100
For this
type of
data Do this when you type a constant Examples
Text Enclose the text in quotation marks (") "Montréal"
"514 555 1212"
Number Don’t include thousand separators or currency
symbols
123
1234.56
Date Use the value as a parameter of the Date function
or TextToDate function. See appendix C,
“Summary of functions.”
Date(2,1,1998)
TextToDate("03/04/199
8")
Time Use the value as a parameter of the Time
function or TextToTime function. See appendix
C, “Summary of functions.”
Time(4,14,32)
TextToTime("02:47:35)