userweeknum( date, methodology )
Returns the week number within the year for the given date or datetime in the user preferred calendar, using a given methodology.
Keyword | Type | Description |
---|---|---|
|
Date |
The date or datetime for which the week number is to be determined. |
|
Number |
Controls what day the week begins on. |
Number
For the methodology parameter, use the following:
You can copy and paste these examples into the Expression Rule Designer to see how this works.
userweeknum(02/06/2006, 1)
returns 6