Day.Monday (1) is an enumeration that specifies a day of the week. It is a member of the Day.Type and represents Monday.
Examples
// June 1st, 2023 is a Thursday
// Returns a day index of 3
= Date.DayOfWeek( #date( 2023, 6, 1 ), Day.Monday)
= Date.DayOfWeek( #date( 2023, 6, 1 ), 1 )
// Sunday as end of the week, returns #date( 2023, 6, 4 )
= Date.EndOfWeek( #date( 2023, 6, 1 ), Day.Monday)
= Date.EndOfWeek( #date( 2023, 6, 1 ), 1 )Related enumerations
Other related enumerations are:
Applies to
Here’s a list of functions that work with Day.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy