Hi, I have a membership database I'm working on and the problem I'm tearing what's left of my hair out over is this:
If the date of joining the club is <= 15th of that month then the renewal date is 1st of that same month in the following year.
However, if the date of joining the club is >15th...