GetWeekNumber ( selDate )

Gets the Week Number within in the Month of a selected date.

Average rating: 4.0 (38 votes) Log in to vote

Don Wieland - Show more from this author
DW Data Concepts
http://www.dwdataconcepts.com

Sample input:

GetWeekNumber ("3/16/2005")

Sample output:

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

Let([
s=selDate;
v = DayOfWeek(Date(Month ( s );1;Year ( s )));
w=9 - v;
x=w+7;
y=x+7;
z=y+7;
zz=z+7;
a=Day ( s )

];

Case(a < w; 1; a < x; 2; a < y; 3; a < z; 4; a < zz; 5; 6))

Gets the Week Number within in the Month of a selected date.

Comments

		Tobias Oberg, Sweden Jul 10, 2013
How do I do If I want to show what weeks that occur between two dates?

		Kenneth Durrum, Released Solutions Jan 21, 2015
s=selDay should be s=selDate

		Binu Alexander, ASC, Feb 24, 2015
Hi!, I have pasted this into the custom function edit box. When I try to save it says ' the parameter cannot be found' and the selDay is highlighted What are the parameters I should specify? Is there anything else I have to configure ? Thanks

		Carmen, Wichita, KS Feb 5, 2016
Wow, this is exactly what I was looking for to create a calc field. I just want to understand the math behind it all. Why start with 9 and subtract the day of the week, etc? Thanks for your work!

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

GetWeekNumber ( selDate )

Comments

Support this website.

Support this website.