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 - Show more from this author

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)

/*
DayNameDates ( theDayName ; StartDate ; EndDate )
Author: Peter Vinogradov
returns a list of dates for "theDayName" that occur between StartDate and EndDate

REQUIRES: the function NextDayNameDate, by Danielle Raybaudi, taken from "http://www.briandunning.com/filemaker-custom-functions/"



-------------------*/

Let(
  $nextdate = NextDayNameDate( StartDate; theDayName );
  If(
    $nextdate <= EndDate;
    $nextdate &
    If(
      NextDayNameDate( $nextdate + 1; theDayName ) <= EndDate;
      "¶" & DayNameDates( theDayName; $nextdate + 1; EndDate );
      ""
    );
    ""
  )
)

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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

DayNameDates ( theDayName ; StartDate ; EndDate )

Comments

Support this website.

Support this website.