ExplodedKey ( ID ; StartDate ; EndDate )
Combines a text constant (ID) with each date in a date range to make a multi-key that has the text constant on each line
Average rating: 2.5 (195 votes) Log in to vote
Darren Terry - Show more from this author
Pacific Data Management, Inc.
StartDate = "4/1/2004"
EndDate = "4/3/2004"
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This custom function takes a date range and a text constant (ID) and constructs a multi-key that has the ID on every line. It builds the multi-key to contain each of the dates in the date range from StartDate to EndDate.
This function could be easily modified to allow a text constant to be appended to each line of a return-separated list of values.
|Michael, Guilford ,CT
Aug 23, 2012
I have try to use the example for
But it did not work
Jul 7, 2015
|Jerry Friedman, California
Aug 18, 2018
|Brilliant--thank you. I adapted this for numbers instead of dates and it works marvelously.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.