userweeknum() Function

Returns the week number within the year for the given date or datetime in the user preferred calendar, using a given methodology.

Syntax

userweeknum( date, [methodology] )

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

Notes

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

17.1

On This Page

FEEDBACK