Question Need date of the 1st Monday of the current month (1 Viewer)

[ghudson]

Searching has left me dazed and confused on this one.

I need a simple calculation to obtain the date of the first Monday of the current month in a field in a report?

Thanks in advance for your help!

 

[boblarson]

REMOVED URL as the code is not working properly.

 

[ghudson]

Thanks Bob.

Odd, but when I tried...

?GetFirstOfDay("Mon")
or
MsgBox GetFirstOfDay("Mon")

The function returns 5/1/2010 but 5/3/2010 is the 1st Monday in May 2010.

 

[boblarson]

Looks like I'll have to have to fix that, eh?

 

[ghudson]

Refining my search for Raskew helped me find a working solution @ http://www.utteraccess.com/forum/Date-Calculation-next-pr-t541059.html

Thanks Bob!

 

[boblarson]

Glad you got it. I disabled my web page until it is fixed.