Jump to content

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

Recommended Posts

  • Newbies
Posted

Currently have a script in place for one set of info which allows us to enter a number coinciding with a weekly event. (i.e if today + 7...) Would like to assign a new set of data with progression by month.

In other words, one set of data assigned a Monday date. When entering "3" in our frequency field means this data is pulled as active next Monday and the following Monday (4/30/01, 5/07/01 and 5/14/01) Need to have other set of info go from May 1, June 1, July 1.

crazy.gif" border="0

Posted

The following calculation will add one month to a Starting Date.

NextDate = Date(Month(StartDate)+1, Day(StartDate), Year(StartDate))

BTW, it does work correctly for dates that cross over to a new year, since Filemaker rolls over months greater than 12 into the next year automatically.

This topic is 8696 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
×
×
  • Create New...

Important Information

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