Brian Dunning's FileMaker Custom Functions

RangeDateStart ( aRange, aYear )

Calculates the start date for a range based on value list.

  Average rating: 4.6 (30 votes) Log in to vote

Tim Cimbura   Tim Cimbura
LuminFire
http://luminfire.com

Share on Facebook Share on Twitter

  Sample input:
RangeDateStart("Last Year")
  Sample output:
1/1/2006 (Assuming the current year is 2007)

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

Use with RangeDateEnd function. A global start and end date calculated with this function can be used to filter a portal, choose report dates, etc.

Call with values from value list:
This Year
Last Year
Next Year
This YTD
Last YTD
Next YTD
This Quarter
Last Quarter
Next Quarter
Quarter 1
Quarter 2
Quarter 3
Quarter 4
This Month
Last Month
Next Month
January
February
March
April
May
June
July
August
September
October
November
December
This Week
Last Week
Next Week
Today
Yesterday
Tomorrow

 

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.