Caché Basic Reference
Weekday
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Returns a whole number representing the day of the week.
Synopsis
Weekday(weekday[,firstdayofweek])
Arguments
weekday Any expression that can represent a date.
firstdayofweek Optional — A constant that specifies the first day of the week. If omitted, vbSunday is assumed. See Description section for values.
Description
The Weekday function returns an integer between 1 and 7 (inclusive) specifying the day of the week represented by weekday. The first day of the week is, by default, Sunday, or the current NLS day of week setting overriding this default system-wide.
The firstdayofweek argument can be used to set the first day of the week for this statement to the day of your choosing. The firstdayofweek argument can have the following values:
Constant Value Description
vbUseSystem 0 Use National Language Support (NLS) API setting.
vbSunday 1 Sunday
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday
The Weekday function can return any of these values:
Constant Value Description
vbSunday 1 Sunday
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday
Examples
The following example uses the Weekday function to obtain the default day of the week for the specified date:
MyDay0 = Weekday("11/1/2005")
Println MyDay0
 
Nov. 1, 2005 is a Tuesday, so Weekday("11/1/2005") returns 3.
The following example shows the effects of the firstdayofweek argument:
MyDay1 = Weekday("11/1/2005",vbSunday)
MyDay2 = Weekday("11/1/2005",vbMonday)
MyDay3 = Weekday("11/1/2005",vbTuesday)
MyDay4 = Weekday("11/1/2005",vbWednesday)
MyDay5 = Weekday("11/1/2005",vbThursday)
MyDay6 = Weekday("11/1/2005",vbFriday)
MyDay7 = Weekday("11/1/2005",vbSaturday)
Println "Day is: ",MyDay1," Week begins Sunday"
Println "Day is: ",MyDay2," Week begins Monday"
Println "Day is: ",MyDay3," Week begins Tuesday"
Println "Day is: ",MyDay4," Week begins Wednesday"
Println "Day is: ",MyDay5," Week begins Thursday"
Println "Day is: ",MyDay6," Week begins Friday"
Println "Day is: ",MyDay7," Week begins Saturday"
 
See Also