Brian Dunning's FileMaker Custom Functions

RangeDateEnd ( aRange, aYear )

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

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

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

Share on Facebook Share on Twitter

  Sample input:
RangeDateEnd("January", 2008)
  Sample output:
1/31/2008

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

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

Note: The end of "This Quarter" is defined as the current date...assuming there are no date values beyond it.

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.