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 different 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 a month, day, and year.
Day	A number from 1 to 31, for the day of the month on which a date occurs.
DayName	Text that is the full name of the weekday for a date.
DayNameJ	Text in Japanese that is the full name of the weekday for a date.
DayOfWeek	A number representing the day of the week on which a date occurs.
DayOfYear	The number of days from the beginning of the year of a date.
Month	A number from 1 to 12, representing the month of the year in which a date occurs.
MonthName	The full name of the month for a date.
MonthNameJ	The name of the month of a date in Japanese.
WeekOfYear	The number of weeks after January 1 of the year of a date.
WeekOfYearFiscal	A number from 1 to 53, representing the week containing a date, from a starting day.
Year	A number representing the year in which a date occurs.
YearName	The Japanese year name of a date, in the specified format.

Related topics 

About functions

About formulas