Day.Friday (5) is an enumeration that specifies a day of the week. It is a member of the Day.Type and represents Friday.
Examples
// June 1st, 2023 is a Thursday
// Returns a day index of 6
= Date.DayOfWeek( #date( 2023, 6, 1 ), Day.Friday)
= Date.DayOfWeek( #date( 2023, 6, 1 ), 5 )
// Thursday as end of the week, returns #date( 2023, 6, 1 )
= Date.EndOfWeek( #date( 2023, 6, 1 ), Day.Friday)
= Date.EndOfWeek( #date( 2023, 6, 1 ), 5 )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