DriveWorks Pro 15: WeekNum [send feedback...]

WeekNum

This function returns the week of the given date as a number.

Syntax

WEEKNUM([Date],[Return Type])

Date is the date to return the week number from

Return Type is a number representing the day on which the week starts

Return Type

Number returned
1 or OmittedSunday
2Monday
11Monday
12Tuesday
13Wednesday
14Thursday
15Friday
16Saturday
17Sunday
21Monday

Examples

Rule

Meaning
WEEKNUM(Today())If this function is called on 10/18/2010 it will return 43 as the week number
WEEKNUM("10/18/2010",12)This will return 42 as the date given falls on a Monday and the week is set to start on a Tuesday (12).

Table of Contents