DateValues ( date1 ; date2 )
Generates a return delimited list of date for the given range.
Average rating: 4.4 (31 votes) Log in to vote
Jonathan Stark Consulting
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Generates a return delimited list of dates for the given range. This is similar to other functions on this list, but is more permissive in that it does not care if the first date is higher that the second - it will calc the range in either direction. Also, if one value is invalid or null, it will return the other, so a user only has to enter one date of the two in order to filter a portal, for instance.
Jean Dussault, Southbury, CT
Jul 7, 2010
Noticed 2 errors to make this function work.
1. function parameters should be "Date Begin" and "Date End" not" date1 and date2" shown in title.
"dateMin = dateMax ; dateMax ¶; "
"dateMin = dateMax ; dateMax & ¶;"
With those changes it works great. Thanks for posting.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.