Ok, I've been racking my brain about this problem, I have a table that has two date fields on it. One of the date fields is a membership join date and the other field is a membership renewal date. The Membership renewal date field must be 365 days after the membership join date field. How would one go about solving this problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access date validation tables.
- Thread starter lordearp
- Start date
Hi
The short answer is don't. There is no need to hold both dates if the second one can be derived from the first. If you simply hold the MembershipStart Date, in any situation where you want the renewal date you can do it via a query, so:
Renewal(DateAdd("yyyy",1,StartDate)
or if you really want 365 days and not one year (remember leap years)
Renewal(DateAdd("d",365,StartDate)
Hope this helps
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
The short answer is don't. There is no need to hold both dates if the second one can be derived from the first. If you simply hold the MembershipStart Date, in any situation where you want the renewal date you can do it via a query, so:
Renewal(DateAdd("yyyy",1,StartDate)
or if you really want 365 days and not one year (remember leap years)
Renewal(DateAdd("d",365,StartDate)
Hope this helps
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
