Brian Dunning's FileMaker Custom Functions

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   Tim Cimbura
LuminFire
http://luminfire.com

Share on Facebook Share on Twitter

  Sample input:
YearValues ( 2001, 2006)
  Sample output:
2001
2002
2003
2004
2005
2006

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

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

George   George, Sydney, Australia
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.
 

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.

Under construction. Email me your wish list for improvements.