Adding 7 days to date fields

[JPrager]

I have 12 empty date fields named Date#1 Date#2 Date#3 etc. If date one is Aug 10,2001 I would like Date #2 to be Aug 17,2001 by using a script button. I have used this formula Month(Date#1)&/& Day(Date#1+7)&/& Year(Date#1) however it does not change the month if you have Aug 27, 2001 and want it to be Sept 3,2001. Please help!

[Vaughan]

It's easier than you think if you let FMP do the hard calculation for you -- as long as they are Date fields and not text.

In your script, use either the Insert Calculated Result or Set Field step with the function:

Date + 7

Wasn't that easy!