Brian Dunning's FileMaker Custom Functions

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   Jonathan Stark
Jonathan Stark Consulting
http://jonathanstark.com/

Share on Facebook Share on Twitter

  Sample input:
DateValues( "12/26/2005" ; "12/21/2005" )
  Sample output:
12/21/2005
12/22/2005
12/23/2005
12/24/2005
12/25/2005
12/26/2005

  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.

 

Comments

Jean Dussault   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.

2. Line;
"dateMin = dateMax ; dateMax ¶; "
should read;
"dateMin = dateMax ; dateMax & ¶;"

With those changes it works great. Thanks for posting.
 

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.