0 Replies Latest reply on Apr 30, 2013 7:33 AM by pwilliams@rm.com

    Combining two calculations....simple right

    pwilliams@rm.com

      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