userweekday() Function

Returns the day of the week of the specified date or datetime in the user preferred calendar.

Syntax

userweekday( date, [return_type] )

date: (Date) The date or datetime that the day of the week will be calculated from.

return_type: (Number) Control for how the days of the week are numbered.

Returns

Number

Notes

For the return_type parameter, use the following:

  • 1 correlates 1-7 with Sunday-Saturday (default)
  • 2 correlates 1-7 with Monday-Sunday
  • 3 correlates 0-6 with Monday-Sunday

Examples

You can copy and paste these examples into the Expression Rule Designer to see how this works.

userweekday(07/10/2006, 1) returns 1

FEEDBACK