Not weekday
i use something like this, with DtVal being the variable holding the date
If Weekday(DtVal, 2) 5 then
--
Gary
"Arne Hegefors" wrote in message
...
Hello! I have a piece of code that I want to use to check if a certain date
is not a weekday, i.e. Saturday or Sunday. The date is found in the first
position of an array. Code:
If (Day(strStartDatumArray(0)) = 1 Or 7) Then
MsgBox ("not a weekday")
End If
Problem: I get the message that it is not a weekday regardless of what day
it actually is. Can anyone please see what is wrong with this code? Thanks
very much in advance!
|