NextRenewalDate ( ordered ; renewal.period )

Works out the next time a date occurs, within a given yearly cycle.

  Average rating: 4.1 (28 votes) Log in to vote

James Glendinning James Glendinning www.djcreate.co.uk

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Will return the next instance of the given date after today, determined by the number of years.

Useful for determining things like renewal periods on services, which may have renewal periods of 1,2,3 etc. years.

Comments

		TKnTexas, Irving Texas Dec 2, 2012
By the description this would seem to be the CF I need. However I am not sure of how to craft it into my database. Can ORDERED and RENEW.PERIOD take fields? Is ORDERED a field listing the renewal dates by return-delimited?

		James Glendinning, Sydney Dec 2, 2012
Hi TKnTexas, As with all custom functions, you'll need to import this into your filemaker pro database using the Manage Custom Functions area of Filemaker Pro. ORDERED and RENEW.PERIOD are required fields - ORDERED is a date field; RENEW.PERIOD is a positive integer. The result of the calculation is the next renewal date, based upon the current date of the host system. It won't provide a tab-delimited list of dates, unless you write a script to do so.

		TKnTexas, Irving Texas Dec 3, 2012
Thanks James. I got the function into the right place of Filemaker. I am just not understanding it to integrate the function into use.

Log in to post comments.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: