Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
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
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
+ 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
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