AnsweredAssumed Answered

Combining two calculations....simple right

Question asked by pwilliams@rm.com on Apr 30, 2013

Title

Combining two calculations....simple right

Your post

     Hi all,

      

     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).

      

     Thanks in advance as always

     Peter

Outcomes