Date.WeekOfMonth

Syntax

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

About

Returns a number from 1 to 6 indicating which week of the month the date dateTime falls in.

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

Example 1

Determine which week of March the 15th falls on in 2011.

Usage

Date.WeekOfMonth(#date(2011, 03, 15))

Output

3