getListODatesApartFromSatnSun ( startDate ; endDate )

simple recursive function that gives a list of dates

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

Richard Howland-Bolton - Show more from this author
none
http://howlandbolton.com

Sample input:

getListODatesApartFromSatnSun ( 2/2/2006 , 2/12/2006 )

Sample output:

2/2/2006
2/3/2006
2/6/2006
2/7/2006
2/8/2006
2/9/2006
2/10/2006

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

//©RHB 2006
// this runs down from the endDate to the startDate

Case ( 
     endDate > startDate ; 
     Case (
//check first iteration for Sat or Sun
          DayOfWeek ( endDate ) = 1  ; getListODatesApartFromSatnSun ( startDate; endDate - 2)  ;
          DayOfWeek ( endDate ) = 7  ; getListODatesApartFromSatnSun ( startDate; endDate - 1)  ;
//check penultimate iteration for Mon
          DayOfWeek ( endDate ) = 2  and (endDate - 1 = startDate or endDate - 2 = startDate) ; endDate  ;
//rest of the iterations
          DayOfWeek ( endDate ) = 1  ; getListODatesApartFromSatnSun ( startDate; endDate - 2) & "¶" & endDate ;
          DayOfWeek ( endDate ) = 2  ; getListODatesApartFromSatnSun ( startDate; endDate - 3) & "¶" & endDate ;
          getListODatesApartFromSatnSun ( startDate; endDate - 1) & "¶" & endDate 
     ) ; 
     endDate
)

simple recursive function that gives a list of dates. It doesn't check for things like the start date being earlier than the end date (just returns the end date)

Comments

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

getListODatesApartFromSatnSun ( startDate ; endDate )

Comments

Support this website.

Support this website.