Functions Reference

30 FileMaker Functions Reference
Month
Format
Month(date)
Parameter
date - any calendar date
Data type returned
number
Description
Returns a number in the range 1 through 12, representing the number of the month of the
year in which date occurs.
Important To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro Help.
Examples
Month(“3/19/2008”) 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, 2008. (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.
MonthName
Format
MonthName(date)
Parameter
date - any calendar date
Data type returned
text
Description
Returns the full name of the month for date.
Important To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro Help.