U.M. (Mac OS)

C-6 FileMaker Pro User’s Guide
Time functions
Aggregate functions
WeekofYearFiscal
(date, starting day)
Returns the number of weeks elapsed since the first
week of the year of date, using starting day (a number
from 1-7, where 1 is Sunday) as the first day of the
week. The first week of the year is a week that contains
four or more days of that year.
Year (date) Returns a number representing the year portion of date
Choose FileMaker Help Index from the or Help menu, and then type:
E date 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 or 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...)
Syntax Definition