Validate [WeekEnd] Date is only a Sunday

[plang99]

Validate [WeekEnd] Date is only a Sunday

I put in: = Weekday(1) as Validation Rule for [WeekEnd] on Data Tab and get error message. I used the Expression Builder to make it.

Also tried DatePart("d",[WeekEnd])=1 and that didn't work.

The WeekBegin Date is automatically done AfterUpdate of [WeekEnd].

I tired vbSunday and that didn't work.

I tired Weekday([WeekEnd],1) and that didn't work.

Any Suggestions.

 

[Databaseguy]

Dim MyDate As Date
MyDate = #8/27/01#
If WeekDay(MyDate) = 1 Then
MsgBox "Sunday"
Else
MsgBox "Not Sunday"
End If


End Sub
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[plang99]

Tyrone,

I put it in the AfterUpdate along with code to deduct 6 days for the WeekBegin date and it worked.

Thank you,

Paul