Filemaker Pro 8.5 Advanced Educational TH335F/A Manual Do Utilizador
Códigos do produto
TH335F/A
22 FileMaker Functions Reference
Data type returned
text, number, date, time, timestamp
Description
Returns the highest valid value in:
•
•
a repeating field (repeatingField).
•
a field in matching
specified by (table::field), whether or not
these records appear in a
.
•
several non-repeating fields in a
(field1;field2;field3...).
•
corresponding repetitions of repeating fields in a record
(repeatingField1;repeatingField2;repeatingField3), if the result is
(repeatingField1;repeatingField2;repeatingField3), if the result is
returned in a repeating field with at least the same number of repeats.
•
several fields in the first matching record specified by
(table::field1;table::field2;...). You can include fields from different
(table::field1;table::field2;...). You can include fields from different
(table 1::field A;table 2::field B...).
Examples
has a portal showing installment payments made.
Max(Payments::PaymentDate) returns the most recent date a payment was made on
an account.
In the following examples:
•
In the following examples:
•
Field1 contains two repetitions with values of 1 and 2.
•
Field2 contains four repetitions with values of 5, 6, 7, and 8.
•
Field3 contains 6.
Max(Field2) returns
8
when the calculation isn’t a repeating field.
Max(Field1;Field2;Field3) returns
6
,
6
,
7
,
8
when the calculation is a repeating
field.
Note
When a referenced field is a repeating field, the Max function returns the maximum
value in the first repetition field, then the maximum value in the second repetition field, and
so on.
so on.
Min
Format
Min(field{;field...})
Parameter
field - any
,
; or an
that returns a field, repeating field, or set of non-repeating fields.