Functions Reference

36 FileMaker Functions Reference
Examples
Month(“3/19/2004”) 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 16, 2004. (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.
Examples
MonthName(“6/6/2004”) 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/2004.
“Payment for: “ & MonthName(Date(Month(Payment) +
1;Day(Payment);Year(Payment))) returns Payment for: followed by the name of
the month that is one past the month of the last payment.
MonthNameJ
Format
MonthNameJ(date)
Parameter
date - any calendar date