Brian Dunning's FileMaker Custom Functions

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   Darren Terry
Pacific Data Management, Inc.

Share on Facebook Share on Twitter

  Sample input:
ID = "Darren"
StartDate = "4/1/2004"
EndDate = "4/3/2004"
  Sample output:
Darren 731672
Darren 731673
Darren 731674

  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   Michael, Guilford ,CT
Aug 23, 2012
Good Morning

I have try to use the example for

But it did not work

Please advice...


Michael Shakaid

cell: 925-639-0761
rtet   rtet, tet
Jul 7, 2015
Jerry Friedman   Jerry Friedman, California
Aug 18, 2018
Brilliant--thank you. I adapted this for numbers instead of dates and it works marvelously.

Log in to post comments.


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

Under construction. Email me your wish list for improvements.