1 Reply Latest reply on Aug 30, 2009 7:38 AM by LaRetta_1

    Report to display only memberships that have expired

    dinora

      Title

      Report to display only memberships that have expired

      Post

      Membership dues are due each December 1st of every year - How can I make a report to only show me those memberships that have expired based upon date last paid

       

      Thanks

        • 1. Re: Report to display only memberships that have expired
          LaRetta_1
            

          We need more rules.  If today is November 25, 2009 and you want to find all memberships that will expire by December 1st of this year, you will look for any with DateLastPaid of < 12/1/2009.   Or do you want to know ANY members that have a DateLastPaid older than today?

           

          If the first option, perform a find on the DateLastPaid for:  "<" & Date ( 12 ; 1 ; Year ( Get ( CurrentDate ) ) )