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 - Show more from this author
Pacific Data Management, Inc.
http://www.pdm-inc.com

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.

 

Comments

Michael   Michael, Guilford ,CT
Aug 23, 2012
Good Morning

I have try to use the example for
ExplodedKey

But it did not work

Please advice...


Regards

Michael Shakaid

cell: 925-639-0761
mshakaid@gmail.com
 
rtet   rtet, tet
Jul 7, 2015
etetetrte
 
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 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 15 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: