Brian Dunning's FileMaker Custom Functions

DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum )

Pick Nth day of week in specified year and month.

  Average rating: 4.2 (42 votes) Log in to vote

Koji Takeuchi   Koji Takeuchi
TonicNote, Inc.
https://tonic-note.com

Share on Facebook Share on Twitter

  Sample input:
DateByNthDOW ( 2011 ; 3 ; "thu" ; 2 )
  Sample output:
date value of "2011/3/10"

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

DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum )
2011.03.02, Koji Takeuchi

「○年○月の○番目の○曜日」の日付を得る
Pick Nth day of week in specified year and month.

tYear = Year // 2011 or Year ( date_value )
tMonth = Month // 3 or Month ( date_value )
tDayOfWeek = Day of week // "Thursday" or "thu" or "5"
tNum = Number // 1-5

ex:
Pick date value of 2nd Thursday in 2011/03.
DateByNthDOW ( 2011 ; 3 ; "thu" ; 2 ) = date value of "2011/3/10"

 

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.