Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculating a recurring 4 week date


Recommended Posts

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

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


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use