DayOfWeek
Purpose
Returns a number representing the day of the week on which a date occurs.
Format
DayOfWeek(date)
Parameters
date - any calendar date
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
The number 1 represents Sunday, 2 represents Monday, 3 represents Tuesday, and so on. For example, you can find out on what day of the week a holiday occurs.
Examples
DayOfWeek(“10/8/2014”) returns 4.
DayOfWeek(Date(10;9;2014)) returns 5.
DayOfWeek(ProjectDue) returns 3 when the date in ProjectDue is 10/7/2014.
Related topics