Functions Reference

Chapter 3
|
Date functions 25
Chapter 3
Date functions
Date functions calculate dates and manipulate date information.
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.
Note System formats affect the way dates are displayed. See FileMaker Pro Help.
Tip You can use zero (0) and negative numbers as Date function arguments. For example,
the following formula returns 5/31/2008:
Date(6;0;2008)
Click a function name for details.
This function Returns
Date, page 26 The calendar date for the specified month, day, and year.
Day, page 27 A number in the range 1 through 31, representing the day of the month for a
specified date.
DayName, page 27 A text string that is the full name of the weekday for the specified date.
DayNameJ, page 28 A text string that is the full name of the weekday for the specified date in
Japanese.
DayOfWeek, page
28
A number representing the day of the week the specified date falls on.
DayOfYear, page 29 A number equal to the number of days from the beginning of the year of the
specified date.
Month, page 30 A number in the range 1 through 12, representing the number of the month of the
year in which the specified date occurs.
MonthName, page
30
The name of the month for the specified date.
MonthNameJ, page
31
The name of the month in Japanese for the specified date.
WeekOfYear, page
31
The number of weeks after January 1 of the year of the specified date.
WeekOfYearFiscal,
page 32
A number between 1 and 53 representing the week containing a specified date,
figured according to the specified starting day.
Year, page 33 A number representing the year in which the specified date occurs.
YearName, page 33 The Japanese year name of the specified date, provided in the specified format.