Date Functions
FileMaker offers a range of date manipulation functions, including those for the Japanese calendar.
Syntax |
Data Type Returned |
---|---|
Date ( month; day; year ) |
Date |
Day ( date ) |
Number |
DayName ( date ) |
Text |
DayNameJ ( date ) |
Text (Japanese) |
DayOfWeek ( date ) |
Number |
DayOfYear ( date ) |
Number |
Month ( date ) |
Number |
MonthName ( date ) |
Text |
MonthNameJ ( date ) |
Text (Japanese) |
WeekOfYear ( date ) |
Number |
WeekOfYearFiscal ( date; startingDay ) |
Number |
Year ( date ) |
Number |
YearName ( date; format ) |
Text (Japanese) |