FindDay ( StartDate ; EndDate ; DayN )
Find Dates for week days in an Data range.
Average rating: 4.9 (25 votes) Log in to vote
Priyabrata Sahoo, Mindfire Solutions
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
The function finds all the dates for a week day for a given date range.
We need to find what are the dates for the Thurdays in the date range starting from 1/1/2013 to 1/31/2013.
In this case:
The function would be defined as FindDay ("1/1/2014";"1/31/2014";5)
Here the start date and end date in the function parameters are text.
Here the 5 refers to the number that represents Thursday in the week.
For In Valid dates provided in the date range it will return "N".
Function Parameters :
StartDate : Text
EndDate : Text
DayN : Number
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.