iPat Posted March 2, 2005 Share Posted March 2, 2005 For a gym that works on a renewing 4 week membership - not monthly. I enter their beginning date as x/x/xx and need the membership renewal date to show 4 weeks later...and so on. I can do it for the first occurence but I need it to continue every 4 weeks...any suggestions? Thanks! Link to comment Share on other sites More sharing options...
comment Posted March 2, 2005 Share Posted March 2, 2005 I can think of several ways - all depends on how your data is organized. Do you record renewals? I would have 2 tables: Members and Subscriptions. For every renewal, I would make a record in Subscriptions. Then the next renewal date is: Last ( Subscriptions::Date ) + 28 Link to comment Share on other sites More sharing options...
iPat Posted March 2, 2005 Author Share Posted March 2, 2005 Yes - I would like to record the renewals. Excellent idea - thanks! Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.