userweeknum() Function

Function

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.

Parameters

Keyword	Type	Description
date	Date	The date or datetime for which the week number is to be determined.
methodology	Number	Controls what day the week begins on.

Returns

Number

Usage considerations

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

Examples

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 compatibility

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.

Feedback