April 27, 200124 yr Newbies 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.
April 28, 200124 yr 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.
Create an account or sign in to comment