First Monday of the Current Month

[dfaith]

Does anyone know of a way to determine the first Monday of the current month?

I am using version 7.0

Thanks in advance.

 

[kenhamady]

Test this and let me know if it works.
It should work in any version of CR.


WhileReadingRecords;
DateVar BOM;
DateVar BOW;

BOM:= CurrentDate - Day(CurrentDate) + 6;
BOW := BOM - DayOfWeek(BOM)+2

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[dfaith]

Thank you Ken! It worked perfectly. I also found that the following will work since I am only running this for the current month and only need the First Monday for the current month:

totext(month(CurrentDate))+'/'+totext(DayofWeek(CurrentDate - Day(CurrentDate) + 6)+2)+'/'+totext(Year(CurrentDate));