Go to Contents
Previous
Page
Next
Page
Contents > Functions reference (alphabetical list) > Date functions

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 Conversion of dates with two-digit years.
Note   System formats affect the way dates are displayed. See Opening files with foreign system formats.
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
The calendar date for the specified month, day, and year.
Day
A number in the range 1 through 31, representing the day of the month for a specified date.
DayName
A text string that is the full name of the weekday for the specified date.
DayNameJ
A text string that is the full name of the weekday for the specified date in Japanese.
DayOfWeek
A number representing the day of the week the specified date falls on.
DayOfYear
A number equal to the number of days from the beginning of the year of the specified date.
Month
A number in the range 1 through 12, representing the number of the month of the year in which the specified date occurs.
MonthName
The name of the month for the specified date.
MonthNameJ
The name of the month in Japanese for the specified date.
WeekOfYear
The number of weeks after January 1 of the year of the specified date.
WeekOfYearFiscal
A number between 1 and 53 representing the week containing a specified date, figured according to the specified starting day.
Year
A number representing the year in which the specified date occurs.
YearName
The Japanese year name of the specified date, provided in the specified format.

Contents > Functions reference (alphabetical list) > Date functions
Previous
Page
Next
Page