Brian Dunning's FileMaker Custom Functions

DateRange ( StartDate ; EndDate ; RangeLimit )

Creates a multi-key field containing a range of dates.

  Average rating: 3.9 (41 votes) Log in to vote

Andrew Persons   Andrew Persons
Excelisys
http://www.excelisys.com/

Share on Facebook Share on Twitter

  Sample input:
DateRange ( "1/1/2005" ; "1/5/2005" ; 10 )
  Sample output:
1/1/2005
1/2/2005
1/3/2005
1/4/2005
1/5/2005

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

Takes a start date and an end date and creates a text multikey field containing a list of all the dates in that range, inclusive.

 

Comments

Jerry Salem   Jerry Salem, Comcast
Mar 23, 2011
In my experience this function only works if you replace all StartDate references with getasdate(StartDate), and replace all occurrences of EndDate with getasdate(EndDate)

(Both Mac/PC and FM9-11)
 
Kan   Kan, New York
Mar 27, 2014
I have 2 form in 1st form there is Start date and end date
and second form has a date
I want to enter start date and end date and find the date in second table and find the appropate record of that date

Thank you
 
Troy Thomas   Troy Thomas, Australia
Nov 5, 2017
This custom function does not work (at least for me), it would be great if someone could revamp it for version 16.
 
Steve   Steve, Lancaster
Apr 25, 2018
I added this to the calc:

Let (
[
StartDate = GetAsDate ( StartDate ) ;
EndDate = GetAsDate ( EndDate )
] ;
original cf formula here...
)

and it worked in FM16
 

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 20 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: