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.
 
Topics in this section
Date
Day
DayName
DayNameJ
DayOfWeek
DayOfYear
Month
MonthName
MonthNameJ
WeekOfYear
WeekOfYearFiscal
Year
YearName