DayOfWeek                                                                                             Function

 

DAYOFWEEK(theDate as Date)

 

Description

Returns an integer from 1=Sunday to 7=Saturday.

 

Example

Dim theDate as Date

Dim result as Integer

theDate=DateVal(1998,9,27)

result=DayOfWeek(theDate) 'will calculate result=1 because the date is a Sunday