User manual

Using formulas and functions 11-7
Date functions
Use these functions when date is a date field holding a date, or a
calculation or expression with a date result.
Example: Year (Date Of Birth) returns 1962 when the Date of
Birth field holds 1/1/1962.
Important To avoid confusion when using dates, always use four-
digit years. For more information on how FileMaker Pro 5 handles
Year 2000 issues, see www.filemaker.com.
Note System formats affect the way dates are displayed. For
information, choose Help menu > Contents and Index, click the Index
tab, and type System formats.
Time functions
Aggregate functions
Use aggregate functions to calculate statistical data for several or
many fields, field repetitions, or related records.
Aggregate functions operate on
(field...) parameters. Depending on
the
(field...) parameter or parameters you specify, you can aggregate
data for all non-blank values in:
1 several non-repeating fields in a record (field1, field2, field3...)
1 a field in matching related records specified by
(relationship::relatedfield), whether or not these records appear in a
portal.
1 all repetitions in a repeating field (repeatingfield)
1 corresponding repetitions of repeating fields in a record
(repeatingfield1, repeatingfield2, repeatingfield3), if the result is
returned in a repeating field with at least the same number of
repetitions.
1 several fields in the first matching record specified by (relationship
::relatedfield1, relationship::relatedfield2,...). You can name a
different relationship for each related field
(relationship1::relatedfield x, relationship2::relatedfield y...).
Syntax Definition
Date (month, day, year) Returns the calendar date of month, day, year (in
digits), from January 1, 0001. Year must be four digits.
DateToText (date) Returns date as data of type Text.
Day (date) Returns a number representing the day portion of date.
DayName (date) Returns the weekday name of date.
DayofWeek (date) Returns the weekday position of date, from Sunday
(1) through Saturday (7).
DayofYear (date) Returns the number of days elapsed after January 1 of
the year in date.
Month (date) Returns a number representing the month portion of date.
MonthName (date) Returns the month name based on the date given.
Today Returns the current date.
WeekofYear (date) Returns the number of weeks elapsed after January 1
of the year in date, counting fractions of weeks as
whole weeks.
WeekofYearFiscal
(date, starting day)
Returns the number of weeks elapsed after 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.
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) Returns time as data of type Text