My where clause should be just between startdate and enddate...but wheras I have use start of week also in the where clause...

I hope wat I had figured out is right..

Thanks