weeklyRange ( curDate )

Return a readable weekly date range for a given date. Ideal for calendar header.

Average rating: 5.0 (1 vote) Log in to vote

Bruno Pelletier - Show more from this author
Geniewave
https://geniewave.ca/

Sample input:

weeklyRange ( Get ( CurrentDate ) )
weeklyRange ( weeklyRange ( dateField )

Sample output:

Feb 28 - Mar 6, 2021
Feb 14 - 20, 2021

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

Let ( [

	date = curDate ;
	toLast = 7 - DayOfWeek ( date ) ;
	lastDay = date + toLast ;
	firstDay = lastDay - 6 ;
	firstMonth = Left ( MonthName ( firstDay ) ; 3 ) ;
	lastMonth =  Left ( MonthName ( lastDay ) ; 3 ) 

 	   ];

If ( firstMonth = lastMonth ; firstMonth & " " & Day ( firstDay ) & " - " & Day ( lastDay ) & ", " & Year ( firstDay ) ;

	firstMonth & " " & Day ( firstDay ) & " - " & lastMonth & " " & Day ( lastday ) & ", " & Year ( lastDay )
 )

	 )

This function will return the beginning date of the week starting on Sunday and the end date being the Saturday in a readable view for a calendar or a weekly view.

Comments

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

weeklyRange ( curDate )

Comments

Support this website.

Support this website.