Shopping Cart

Search:

Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

GetWeekNumber ( selDate )

Rate this function:

Discuss this Custom Function

Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com

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

Sample Input:
 GetWeekNumber ("3/16/2005")
Sample Output:
 3

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

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

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

This is my Custom Function and I want to edit it

## Discuss:

How do I do If I want to show what weeks that occur between two dates?

Tobias Oberg, Sweden
July 10, 2013 2:37am

s=selDay should be s=selDate

Kenneth Durrum, Miami/Florida
January 21, 2015 2:30pm

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

Binu Alexander, India
February 24, 2015 11:58pm

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?

Carmen, Wichita, KS
February 05, 2016 11:02am

 Your Name: City/Location: Comment: characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted. Answer 2 + 4 =
 Search for Custom Functions:

 Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

 1. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd) (Sat, May 19, 3:55am) 2. @JSONFormatElements ( json ) (Tue, May 15, 3:31am) 3. WindowNamesAll ( dbNames ; excludeCurrentWindow ) (Sat, May 12, 11:34am) 4. RandomChoiceFromList ( values ; required ) (Wed, May 02, 6:35am) 5. @JSONFormatElements ( json ) (Fri, Apr 27, 7:31am) 6. MBS-OCR ( language ; Image ) (Mon, Apr 23, 1:48pm) 7. MBS_Image_Rotate ( Picture ; rotation ) (Mon, Apr 23, 1:27pm) 8. UnQuote ( string ) (Tue, Apr 10, 12:34pm)