FunctionCopy link to clipboard
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.
ParametersCopy link to clipboard
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. |
ReturnsCopy link to clipboard
Number
Usage considerationsCopy link to clipboard
For the methodology parameter, use the following:
- 1 if the week begins on Sunday (Default)
- 2 if the week begins on Monday
- 3 if the week begins on Tuesday
- 4 if the week begins on Wednesday
- 5 if the week begins on Thursday
- 6 if the week begins on Friday
- 7 if the week begins on Saturday
ExamplesCopy link to clipboard
You can copy and paste these examples into the Expression Rule Designer to see how this works.
userweeknum(02/06/2006, 1)
returns 6
Feature compatibilityCopy link to clipboard
The table below lists this function's compatibility with various features in Appian.
Feature | Compatibility | Note |
---|---|---|
Portals | Partially compatible | Can be used with Appian Portals if it is connected using an integration and web API. |
Offline Mobile | Partially compatible | Can be used with offline mobile if it is loaded at the top of the form. |
Sync-Time Custom Record Fields | Incompatible | |
Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Incompatible | Cannot be used to configure a process report. |
Process Events | Incompatible | Cannot be used to configure a process event node, such as a start event or timer event. |