Problem with Day of week for Date in Function. 1

[ffleitas]

Hello programmers,

If I place this in a VB function:

[Date2] = Date - Weekday(Date) + 2

field [Date2] being today's date of Monday 07/21/03 would it equal Date - Weekday(Date) +2? If not what would be the correct formula for them to equal?

I am trying to get a condition to run if true ex.
If [Date2] = Date - Weekday(Date) + 2 Then
DoCmd.RunMacro stDocMonday

Thanks

 

[DrSimon]

Forgive me, but if you're trying to run a macro on a Monday why not use the following?
If Weekday([Date2]) = vbMonday Then DoCmd.RunMacro stDocMonday
Simon Rouse