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