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 Entering 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/2019:
Date(6;0;2019)
Click a function name for details.
 
This function
Returns
The calendar date for a month, day, and year.
A number from 1 to 31, for the day of the month on which a date occurs.
Text that is the full name of the weekday for a date.
Text in Japanese that is the full name of the weekday for a date.
A number representing the day of the week on which a date occurs.
The number of days from the beginning of the year of a date.
A number from 1 to 12, representing the month of the year in which a date occurs.
The full name of the month for a date.
The name of the month of a date in Japanese.
The number of weeks after January 1 of the year of a date.
A number from 1 to 53, representing the week containing a date, from a starting day.
A number representing the year in which a date occurs.
The Japanese year name of a date, in the specified format.
Related topics 
About functions
About formulas
Was this topic helpful? Send feedback.