Table of contents
Collapse the table of content
Expand the table of content


Owen Duncan|Last Updated: 10/5/2018
1 Contributor

Date.WeekOfYear(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number


Returns a number from 1 to 54 indicating which week of the year the date, dateTime, falls in.

  • dateTime: A datetime value for which the week-of-the-year is determined.

Example 1

Determine which week of the year March 23rd, 2011 falls in (#date(2011, 03, 23)).

Date.WeekOfYear(#date(2011, 03, 23))


© 2018 Microsoft