Functions Reference

FILEMAKER FUNCTIONS REFERENCE 41
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Examples
Month(“3/19/2014”) 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, 2014. (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.
Important To avoid errors when using dates, always use four-digit years. For more information
about how FileMaker Pro handles two-digit dates, see Conversion of date with two-digit years.
Related topics
Contents
Functions reference (alphabetical list)
MonthName
Purpose
Returns the full name of the month for date.
Format
MonthName(date)
Parameters
date - any calendar date
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Examples
MonthName(“6/6/2014”) returns June.
“Payment due by the end of: ” & MonthName(Date(Month(InvoiceDate) +
1;Day(InvoiceDate);Year(InvoiceDate)))
returns Payment due by the end of May,
where InvoiceDate is 4/4/2014.