advancing by month in calculation?

[Filemaker]

Need help in setting up a calculation.

Database changing from having multiple issues advance from weekly to monthly. Previously based this on adding 7 days to "today" but now need only add (1) to each month but not sure best way to go about this. For example, you'd like to run your ad with us 3 times. First run date is 3/1/01, number of issues requested is 3 so you'll be covered in 4/1/01 and 5/1/01 editions. Would like to enter 3 and have datebase calculate this automatically. Anyone with insight... your help would be so appreciated.

[BobWeaver]

It depends how you want to handle dates like January 31. If you add 30 days to it you get March 3. Is that okay? If so, use your existing calculation, but add 30 instead of 7. If not okay, you will have to decide how to handle these dates.

If your issues are always on the first day of the month, you can advance the dates as follows:

NextDate = Date(Month(LastDate+31),1,Year(LastDate+31))

[Moon]

If you simply want to advance to the same day of a following month, try this.

Fields: Date

NmbrOfMonths

NewDate

NewDate = Date(month(Date) + NmbrOfMonths, Day(Date), Year(Date))

Works for me.

[LiveOak]

What is a month later than March 31? .

-bd