Brian Dunning's FileMaker Custom Functions

GetWeekNumber ( selDate )

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

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

Don Wieland   Don Wieland
DW Data Concepts

Share on Facebook Share on Twitter

  Sample input:
GetWeekNumber ("3/16/2005")
  Sample output:

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

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



Tobias Oberg   Tobias Oberg, Sweden
Jul 10, 2013
How do I do If I want to show what weeks that occur between two dates?
Kenneth Durrum   Kenneth Durrum, Released Solutions
Jan 21, 2015
s=selDay should be s=selDate
Binu Alexander   Binu Alexander, India
Feb 24, 2015
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 ?

Carmen   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!

Log in to post comments.


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

Under construction. Email me your wish list for improvements.