U.M. (Windows)

C-6 FileMaker Pro User’s Guide
Time functions
Aggregate functions
Syntax Definition
Hour (time) Returns the hour portion of time
Minute (time) Returns the minutes portion of time
Seconds (time) Returns the seconds portion of time
Time (hours, minutes, seconds) Returns hours, minutes, seconds (as digits) as a time, in
the current time field format
TimeToText (time) Converts time to text
Choose FileMaker Help Index from the Help menu, and then type:
E time functions
Syntax Definition
Average (field)
Average (relationship::field)
Average (field1, field2,...)
Average (relationship::field1,
relationship::field2...)
Returns the average of nonblank values in a single
repeating field (field) or (relationship::field)
Returns the average of nonblank values in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Count (field)
Count (relationship::field)
Count (field1, field2,...)
Count (relationship::field1,
relationship::field2...)
Returns the number of nonblank values in a repeating
field (field) or (relationship::field)
Returns the number of nonblank values in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Max (field)
Max (relationship::field)
Max (field1, field2,...)
Max (relationship::field1,
relationship::field2...)
Returns the highest nonblank value in a repeating field
(field) or (relationship::field)
Returns the highest nonblank value in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
Min (field)
Min (relationship::field)
Min (field1, field2,...)
Min (relationship::field1,
relationship::field2...)
Returns the lowest nonblank value in a repeating field
(field) or (relationship::field)
Returns the lowest nonblank value in each
corresponding repetition of one or more repeating or
non-repeating fields (field1, field2,...) or
(relationship::field1, relationship::field2...)
?