Paraskavedekatriaphobia ( startDate ; howMany ; resultList )

This function returns a list of dates that are Friday the 13th.

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

Rob Westergaard - Show more from this author
DataStorm Solutions
http://www.DataStorm-Solutions.com

Sample input:

Paraskavedekatriaphobia ( "7/13/2006" ; 4 ; "" )

Sample output:

10/13/2006
4/13/2007
7/13/2007
6/13/2008

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

If ( howMany ; 
     If ( DayOfWeek ( startDate ) = 6 and Day ( startDate ) = 13 ; 
          Paraskavedekatriaphobia ( startDate + 1 ; howMany - 1 ; If ( IsEmpty ( resultList ) ; "" ; resultList & "¶" ) & startDate ) ; 
          Paraskavedekatriaphobia ( startDate + 1 ; howMany ; resultList ) ) ; 
     resultList 
)

This function returns a list of dates that are Friday the 13th.

Parameters:
startDate = The starting date.
howMany = How many matching dates to find.
resultList = The function result (should be "" to start).

Comments

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

Paraskavedekatriaphobia ( startDate ; howMany ; resultList )

Comments

Support this website.

Support this website.