WEEK NUMBER
Description
Will take a date and provide the week number for the date.
Parameters
Options
| Input Parameter Values | Input Values |
|---|---|
| Calendar Week Rule | First Day of Year, First Four-Day Week, or First Full Week (Required) |
| Week Count Start Index | Column or Literal (Required) |
| First Day of the Week | Day of the Week Selections (Required) |
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Date Literal | ✔ |
Remarks
Used in Quick Calculations for corresponding data field type.
We do not support ISO 8601 Week of Year.
To create an ISO 8601 Week of Year, create a formula calculation with the logic similar to this:
If (Day of Week([Order Date] ) = 'Monday'
OR Day of Week([Order Date] ) = 'Tuesday'
OR Day of Week([Order Date] ) = 'Wednesday',
Week Number(Date Offset([Order Date], Offset unit:"Day", Relative offset:3) ),
Week Number([Order Date]))
Note
Review Microsoft information regarding week of year formatting for additional information
Calendar week rule. This option indicates what will be designated the first 'week' of the year.
Is it...
- the week containing January 1st for current year
- the first week with at least 4 days in it for current year
- the first full week of the year
Example
- Input: 01/23/2015
- Quick Calculations > Date > Week Number
- Output: 4