Reference > Functions reference > Date functions > DayOfWeek
 
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.
Important  To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Entering dates with two-digit years.
Examples 
DayOfWeek ( "10/8/2019" ) returns 3.
DayOfWeek ( Date ( 10 ; 9 ; 2019 ) ) returns 4.
DayOfWeek ( ProjectDue ) returns 4 when the date in ProjectDue is 10/9/2019.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas