YearValues ( Year1, Year2 )
Generates a return delimited list of years for the given range.
Average rating: 4.2 (26 votes) Log in to vote
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.
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.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.