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