
how to determine "last week"
'dlbjr
Set ObjDT = New DateTool
strMonday = ObjDT.PriorMonday
strFriday = ObjDT.PriorFriday
Set ObjDT = Nothing
msgbox "Monday = " & strMonday & " and Friday = " & strFriday
Class DateTool
Private mdtmSetDate
Private mintDayOfWeek
Private Sub Class_Initialize()
mdtmSetDate = Date
SetDay
End Sub
Private Sub Class_Terminate()
End Sub
Public Property Let SetDate(strData)
If IsDate(strData) Then
mdtmSetDate = strData
SetDay
End If
End Property
Public Function PriorMonday()
Select Case CInt(mintDayOfWeek)
Case 1
intDiff = 6
Case Else
intDiff = mintDayOfWeek - 2
End Select
PriorMonday = DateAdd("d",-intDiff,mdtmSetDate)
End Function
Public Function PriorFriday()
PriorFriday = DateAdd("d",-3,PriorMonday())
End Function
Private Sub SetDay()
mintDayOfWeek = DatePart("w",mdtmSetDate)
End Sub
End Class