Hi,

I'm trying to create a field that will tell me whether someones membership is current or not. By current I mean renewed within the last 18 months. I have an expiration date field so I would like the new "current membership status" field to be a calculation that used the case formula (I think)that would give me either "okay" or "expired" as the result.

Am I on the right track? I just can't seem the calculation to work. Here's what I've come up with so far:

Case(GetField(current date) >= Date( Month(expire date), Day(expire date) , Year(expire date)),"expired","okay")

But I'm stuck with how to figure out 18 months calculation.... Do I use the month (expire date) + 18)?

Hope this makes sense.

Thanks, MT

Based off of the last renewal date.

Case (

       Date( Month( renewal_date ) + 18, 

             Day( renewal_date ), 

             Year( renewal_date ) 

           ) < Status( CurrentDate),         

       "Okay",

       "Expired"

      )

It may be desirable to perform a Find for only those members that are still active or only those whose membership has expired. If this is the case for you, then I'd suggest calculating the Expiration Date, then performing a Find for those greater than or less than the current date, depending on what you're looking for. This is much more efficient than trying to search for those members whose calculated Status is "Expired" or "Okay".

Thanks that worked with one minor change...< to >

I really appreciate it.

MT