MondayOfFirstWeekOfYearFiscal ( yearNumber )

Returns the date of the Monday of the first week of the year received as input.

Be the first to rate this function Log in to vote

Federico Severin - Show more from this author
Sevesoftware Engineering
http://www.sevesoftware.it

Sample input:

MondayOfFirstWeekOfYearFiscal ( 2024 )

Sample output:

01/01/2024 /* The date of Monday of week 1 for the year 2024 */

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

/*
v1.0 15/02/2024 by Federico Severin

MondayOfFirstWeekOfYearFiscal ( yearNumber )

Parameters:
- yearNumber: number of the year you need.

Output: date of the monday of the first week of the year received as input.

*/



Let ( [
	~firstDayOfTheYear = Date ( 1 ; 1 ; yearNumber ) ;
	~firstDayOfYearWeekFiscal = WeekOfYearFiscal ( ~firstDayOfTheYear ; 2 ); // can be 52, 53 or 1.
	~firstDayOfYearNumber = DayOfWeek ( ~firstDayOfTheYear );
	~differenceWithMonday = ~firstDayOfYearNumber - 2; // 2 is the day number for monday in FM
	~differenceWithMondayOfWeekOne = If ( ~firstDayOfYearWeekFiscal > 1 and ~differenceWithMonday > 0; 
		~differenceWithMonday - 7 ; // if first day of year falls in week 52 or 53 and is not sunday
		~differenceWithMonday // if first day of year falls in week 1 or is a sunday of a previous week
	)
];

	Date ( 1 ; 1 - ~differenceWithMondayOfWeekOne ; yearNumber )
)

Returns the date of the Monday of the first week of the year received as input.
Can be useful if you need to deal with year weeks, for example to make a calendar or planning or any other data presentation on weekly basis.

Comments

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

MondayOfFirstWeekOfYearFiscal ( yearNumber )

Comments

Support this website.

Support this website.