Brian Dunning's FileMaker Custom Functions

DateRangePast ( refdate ; mos )

Starting with your reference date calculate a range backward x months

  Average rating: 4.4 (36 votes) Log in to vote

Atalanta   Atalanta
Imagination Design
http://www.goldapples.com

Share on Facebook Share on Twitter

  Sample input:
DateRangePast(get(currentdate) ; 6)
  Sample output:
11/1/2010...4/30/2011 (when the current date is 05/05/2011 and you want to look at the past 6 months)

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

This is to get a range of dates begining with the first of the month, x mos in the past through the last day of the previous month. The refdate must be a valid date and the mos must be a valid number.

 

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.