Day.Friday

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:

• Day.Monday
• Day.Saturday
• Day.Sunday
• Day.Thursday
• Day.Tuesday
• Day.Wednesday

Applies to

Here’s a list of functions that work with Day.Type:

• Date.DayOfWeek
• Date.EndOfWeek
• Date.StartOfWeek
• Date.WeekOfMonth
• Date.WeekOfYear

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.