week2month ( week ; inYear ; wholeWeeks )

Convert week of year into human readable format

Be the first to rate this function Log in to vote

belg4mit - Show more from this author

Sample input:

week2month(48; 0; 0)

Sample output:

Week 4 of November /* in 2021 */

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

Let([
/* week2month( week; inYear; wholeWeeks ) */
/* Defaults      26;    Now;         0    */
/* Counts from Sunday if wholeWeeks is true */
/* uses https://www.briandunning.com/cf/2174 */

inYear=||(inYear; Year( Get(CurrentDate) ));
week=||(week; 26);
wholeWeeks=||(wholeWeeks;0);


first=Date(1; 1; inYear);
offset=DayOfWeek(first);
start=MonthName(first+ (week-1)*7);
end=MonthName(first+ (week)*7-offset*wholeWeeks)
];

If(start=end;
	"Week " & week-WeekOfYear( Date(Month(first+(week-1)*7); 1; inYear))+1  & " of " & start;
	start & "/" & end)
)

Converts week of year to week of month or, for weeks that fall across months, gives both possible months.

Comments

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

week2month ( week ; inYear ; wholeWeeks )

Comments

Support this website.

Support this website.