Home > Reference > Functions reference > 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/2014:

Date(6;0;2014)

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.