I'm creating a database for a local community centre and they've asked if there's a way I can include information on whether someone has paid their membership fees for the year.
Membership fees fall due on the 1st January each year, so no matter when after that date the member pays the next...