Functions Reference

FILEMAKER FUNCTIONS REFERENCE 35
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Examples
DayOfYear(Billing Date) returns 32, when Billing Date is 2/1/2010.
The following formulas return the total number of days in the current year:
DayOfYear(Date(12;31;Year(Get(CurrentDate))))
DayOfYear(Date(1;1;Year(Get(CurrentDate)) + 1) -1)
Important To avoid errors when using dates, always use four-digit years.
Contents
Functions reference (alphabetical list)
Month
Purpose
Returns a number in the range 1 through 12, representing the number of the month of the year in
which
date occurs.
Format
Month(date)
Parameters
date - any calendar date
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Examples
Month(“3/19/2010”) returns 3. This example assumes that the operating system date format is
set to MM/DD/YYYY.
Month(Payment) returns 3, where Payment contains March 19, 2010. (The Payment field must be
of type date.)
“Bill Due by: ” & Date(Month(DateSold) + 1;Day(DateSold);Year(DateSold))
returns Bill Due by: followed by a value that is one month later than DateSold.