trying to combine two calculations that I currently have :-
This one finds any records that have a date range that falls in "This week" and works beautifully
( Get ( CurrentDate ) - DayOfWeek ( Get ( CurrentDate ) ) + 1 ) & "..." & ( Get ( CurrentDate ) + 7 - DayOfWeek ( Get ( CurrentDate ) ) )
And this one takes a date and adds 3 months to it :-
Date ( Month ( Date agreed) + 3 ; Day ( Date agreed) ; Year ( Date agreed) )
What I can't get my head around is how to combine these to effectively search on a range of dates in a field so that I can return all records that will fall in a week period 3 months after the stored date. (i.e. all clients who have been members for 3 months who joined in the same week).