Jump to content

Adding 7 days to date fields


This topic is 7366 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

This topic is 7366 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.