These three categories provide functions that manipulate date and time values.
Date Function Reference
Date functions are used to create and manipulate dates. FileMaker provides the following built-in date functions:
Date
Day
Day Name
DayNameJ
DayOfWeek
DayOfYear
Month
MonthName
MonthNameJ
WeekOfYear
WeekOfYearFiscal
Year
YearName
Date
The Date function creates a date object from separate numeric month, day, and year values.
Format | Date ( month ; day ; year ) |
Parameters | month = a number indicating a month. day = a number indicating ... |