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
http://none.com

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)

//Function                   : DateRangeBySpan  ( Begin ; End ;  Term )
//Name                        : DateRangeBySpan
//Parameter List          : ( Begin ; End ;  Term )

// Creator                   :  Robert Schaub
// Date		   :05/06/2013

// Parameters	   : begin - given datefield
// Parameters	   : end - given datefield
// Parameters             :Term , enter the number of days in between


Case ( 
end > begin and not IsEmpty ( begin ) and not IsEmpty ( end ); 
DateRangeBySpan( begin  ; end - Term  ;Term))
 &  end -0  & "¶"

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, 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

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

DateRangeBySpan ( Begin ; End ; Term )

Comments

Support this website.

Support this website.