Brian Dunning's FileMaker Custom Functions

NthDayOfWeek ( MyDate )

NthDayOfWeek returns the occurence of the weekday of AValue in the month. // Ceiling ( Day ( date ) / 7 )

  Average rating: 4.5 (37 votes) Log in to vote

Mehmet KAYA   Mehmet KAYA
Beyaz Bilgisayar
http://www.filemakerturk.com

Share on Facebook Share on Twitter

  Sample input:
#NthDayOfWeek ( 24.04.1997 )
  Sample output:
4

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

Bir günün haftanın kaçıncı günü olduğunun rakamsal değerini verir / NthDayOfWeek returns the occurence of the weekday of AValue in the month. This is the N-th time that this weekday occurs in the month (e.g. the third saturday of the month) // Ceiling ( Day ( date ) / 7 ) is a same.

 

Comments

Tahsin Beyazit   Tahsin Beyazit, Turkey
Apr 5, 2010
İt is realy usefull. Filemaker must inculude this fiction in the DATE fictions.
 
comment   comment, VR
Apr 5, 2010
How about:

Ceiling ( Day ( date ) / 7 )
 
Anni Mesman   Anni Mesman, Finland
Apr 6, 2010
Ceiling ( Day ( date ) / 7 ) realy good.. easy end agressive solition. Nice...
 

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.