Not weekday
 

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!

Not weekday
 

Arne,
Try this:
Debug.Print Weekday(Now(), vbSunday)

There are a few options for the 2nd argument, depending what you want.

NickHK

"Arne Hegefors" ...
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!

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!

Not weekday
 

On Wed, 16 Aug 2006 06:10:03 -0700, Arne Hegefors
wrote:

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!


What was the problem with the answers that were posted to you same question
about an hour ago? It would be useful to give the results of those attempts,
before just blindly repeating the question.
--ron