Help with Date calculation please!

[Merit Solutions]

I have a table of Subscribers to a newsletter and a table of Subscriptions. I store the date they became a subscriber (JoinDate)but would like a quick and easy way to set their renewal date to be one year plus one month after their joining date. Obviously this has to take into account leap years etc..

Any helpful calculation would be much appreciated. Thank you

[Søren Dyhr]

Make a calc'field containing this:

Date ( 1+Month ( joinDate ) ; Day ( joinDate ) ; 1+Year ( joinDate ) )

...the result should be of date-type as well!

--sd

[mr_vodka]

If the renewal field needs to be manually modified, you can have your renewal date field be an auto-entry calcuated value of something like:

Date ( month ( registrationdate ) +13 ; day ( registrationdate ) ; year ( registrationdate ) )

* Edit: My post, posted late. Sorry Soren.

Edited May 25, 2007 by Guest
Post delayed

[comment]

See also here.

[Merit Solutions]

That's fine - thanks very much for the tip about the auto entry option - i forgot to mention amendment!