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
Beyaz Bilgisayar
http://www.filemakerturk.com

Sample input:

#NthDayOfWeek ( 24.04.1997 )

Sample output:

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

Let ( [ 
MyMonth = Month( MyDate );
MyYear = Year( MyDate );
MyFirstDate = Date ( MyMonth ; 1 ; MyYear );
MyFirstDateWeekID = WeekOfYear ( MyFirstDate ) ; 
MyDateWeekID = WeekOfYear ( MyDate )  ]; 
If (DayOfWeek ( MyFirstDate )  >  DayOfWeek ( MyDate ); MyDateWeekID - MyFirstDateWeekID; MyDateWeekID - MyFirstDateWeekID + 1)
)

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, Turkey Apr 5, 2010
Ä°t is realy usefull. Filemaker must inculude this fiction in the DATE fictions.

		comment, VR Apr 5, 2010
How about: Ceiling ( Day ( date ) / 7 )

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

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

NthDayOfWeek ( MyDate )

Comments

Support this website.

Support this website.