Functions Reference

Date functions
F
ILEMAKER PRO FUNCTIONS REFERENCE 48
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 n
umbers 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.