AnsweredAssumed Answered

Validation of membership by date refernce

Question asked by MikeWilliams on Jun 3, 2014
Latest reply on Jun 4, 2014 by MikeWilliams


Validation of membership by date refernce


     Hi - I'm a newbie and finding FM fun and pretty intuitive, but I'd like some help with one function I'm trying to get right.

     We have a supporter membership database. We record the date a member joins, and the renewal date is automatically calculated (+365) and displayed as part of each record. So a member may join on 2 May 2014 and the renewal shows up as 1 May 2015.

     What I'd like to be able to do is have the status of each record displayed as a result of the information in the renewal field. For example, if the renewal date is later than the current date (whenever the record may be accessed) a message displays to say 'Current' (or maybe a green check mark) ...and conversely 'Overdue' (or a red cross) if the reverse applies and the renewal date has already passed. Objective is to make it easy to spot those who need a gentle reminder.

     Seems to me this should be relatively easy to achieve... Is it?