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")
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!
Microsoft ISV Community Center Forums2