Reference > Functions reference > Date functions > DayOfWeek
 

DayOfWeek

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.

Example 1 

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