Functions Reference

Date functions
F
ILEMAKER FUNCTIONS REFERENCE 50
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.