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
http://www.dwdataconcepts.com

Share on Facebook Share on Twitter

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

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

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

 

Comments

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
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   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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.