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?