Brian Dunning's FileMaker Custom Functions

DayNameDates ( theDayName ; StartDate ; EndDate )

returns a list of dates for "theDayName" that occur between StartDate and EndDate

  Average rating: 4.3 (28 votes) Log in to vote

Peter Vinogradov   Peter Vinogradov

Share on Facebook Share on Twitter

  Sample input:
DayNameDates ( "Thursday"; "2/22/2007"; "3/22/2007")
  Sample output:
2/22/2007¶
3/1/2007¶
3/8/2007¶
3/15/2007¶
3/22/2007

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

NOTE: requires the function NextDayNameDate, by Danielle Raybaudi

recursive function that returns a value list of all the dates with a given weekday name that fall within a range of dates.

 

Comments

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.