Newbies JPrager Posted August 19, 2001 Newbies Share Posted August 19, 2001 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! Link to comment Share on other sites More sharing options...
Vaughan Posted August 19, 2001 Share Posted August 19, 2001 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! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8277 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now