Functions Reference

Chapter 3
|
Date functions 37
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/2003”) returns
WeekOfYear
Format
WeekOfYear(date)
Parameter
date - any calendar date
Data type returned
number
Description
Returns the number of weeks after January 1 of the year of date. Fractions of weeks
occurring at the beginning or end of the year count as full weeks, so the WeekOfYear
function returns values 1 through 54.
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
WeekOfYear(“1/1/2005”) returns 1.
WeekOfYear(ProjectDue) returns 6, when ProjectDue is 2/2/2005.
WeekOfYearFiscal
Format
WeekOfYearFiscal(date;startingDay)
Parameters
date - any calendar date
startingDay - any number between 1 and 7, where 1 represents Sunday