Functions Reference

28 FileMaker Functions Reference
Examples
DayName(Date(10;7;2008)) returns Tuesday.
DayName(ProjectDue) returns Tuesday when ProjectDue is 10/7/2008.
DayName(“10/7/2008”) returns Tuesday.
“Return your selection by “& DayName(DueDate) displays the text Return
your selection by followed by the name of the day stored in DueDate.
DayNameJ
Format
DayNameJ(date)
Parameter
date - any calendar date
Data type returned
text
Description
Returns a text string in Japanese that is the full name of the weekday for date.
Important To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro Help.
Example
DayNameJ(Date(4;4;2008)) returns
DayOfWeek
Format
DayOfWeek(date)
Parameter
date - any calendar date
Data type returned
number