Brian Dunning's FileMaker Custom Functions

QuarterWeek ( TheDate )

Returns the week number for a given quarter

  Average rating: 2.5 (2 votes) Log in to vote

Ibrahim Bittar Torres   Ibrahim Bittar Torres
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Share on Facebook Share on Twitter

  Sample input:
QuarterWeek ( Date ( 12 , 26 , 2017 )
  Sample output:
13

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

This function returns the week number for a quarter, based on a given date.

Assuming each quarter has 13 weeks, it will return from 1 to 13, depending on the given date.

 

Comments

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.