YearValues ( Year1, Year2 )

Generates a return delimited list of years for the given range.

Average rating: 4.2 (26 votes) Log in to vote

Tim Cimbura - Show more from this author
LuminFire
http://luminfire.com

Sample input:

YearValues ( 2001, 2006)

Sample output:

2001
2002
2003
2004
2005
2006

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

Let ( [
    yearMin = Min ( Year1 ; Year2 );
    yearMax = Max ( Year1 ; Year2 );
    yearList = Case ( 
        yearMin < 100 or yearMin > 3000 ; "?"; // Bad years
        yearMax < 100 or yearMax > 3000 ; "?"; // Bad years
        yearMin = yearMax ; yearMax & ¶; // Last value
        yearMin & ¶ & YearValues ( yearMin + 1 ; yearMax ) // Recursively build years between
    );
    result = yearList
];
    result
 )

YearValues generates a return delimited list of years for the given range. It does not care if the first year is higher than the second. It will calculate the range in either direction. If one value is invalid or null, it will return the other. This makes it useful for filtering a portal, so a user only has to enter one year of the two.

Comments

		Mar 25, 2012
What is it that would be considered a "Bad year" as defined by the IsValid function? You can enter "A" as a year and that is considered "valid"! But it doesn't return sensible results. This is not correct usage of the IsValid function.

		Alex Bassin, SYNAP Aug 29, 2019
Check out a months and Year Calc as well https://www.briandunning.com/cf/2294

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

YearValues ( Year1, Year2 )

Comments

Support this website.

Support this website.