Brian Dunning's FileMaker Custom Functions

DateRangeBySpan ( Begin ; End ; Term )

Gives a date range separated by the term you input

  Average rating: 4.8 (25 votes) Log in to vote

Robert Schaub   Robert Schaub
Robert Schaub
http://none.com

Share on Facebook Share on Twitter

  Sample input:
DateRangeBySpan (DateRangeList:Start Date ;DateRangeList::End Date;7)
  Sample output:
5/6/2013
5/13/2013
5/20/2013
5/27/2013
6/3/2013
6/10/2013
6/17/2013
6/24/2013
7/1/2013

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

This function will allow you to define a date range separated by the term you enter. You enter a number in the Term parameter. Begin and end are self explanitory.

 

Comments

Robert Schaub   Robert Schaub, East Hampton CT
May 6, 2013
BTW I can't seen to get this to work with a number field for Term. It gives various results depending on Start date and Term. So I would stick to a hard coded number in the term parameter for now
 

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.

Under construction. Email me your wish list for improvements.