WeekOfMonth ( )
Function stats
Function overview
Prototype
Parameters
Description
Tags: date
WeekOfMonth ( _date ; startingDay ) custom function ( not recursive)
Author:
Daniele Raybaudi
Parameters:
_date - any calendar date
startingDay - any number between 1 and 7, where 1 represents Sunday
Data type returned:
number
Description:
Returns a number between 1 and 6 representing the week containing date, figured according to startingDay. startingDay indicates which day is considered the first day of the week.
Examples
Sample input
WeekOfMonth ( "06/07/2009" ; 2 )
Sample output
1
Function code
WeekOfMonth ( _date ; startingDay ) custom function ( not recursive)
Author:
Daniele Raybaudi
Parameters:
_date - any calendar date
startingDay - any number between 1 and 7, where 1 represents Sunday
Data type returned:
number
Description:
Returns a number between 1 and 6 representing the week containing date, figured according to startingDay. startingDay indicates which day is considered the first day of the week.
*/
Let(
first = Date ( Month ( _date ) ; 1 ; Year ( _date ) );
WeekOfYear ( _date ) - WeekOfYear ( first ) + 1 - ( DayOfWeek ( _date ) = startingDay - 1 ) + ( DayOfWeek ( first ) = startingDay - 1 )
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/229
Prototype: WeekOfMonth( _date; startingDay )
Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
Last updated: 09 June 2009
Version: 1
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
