Functions Reference

Chapter 3
|
Date functions 31
Examples
MonthName(“6/6/2008”) 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/2008.
“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
Data type returned
text
Description
Returns the name of the month of date in Japanese.
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.
Example
MonthNameJ(“6/6/2008”) returns
WeekOfYear
Format
WeekOfYear(date)
Parameter
date - any calendar date
Data type returned
number