Brian Dunning's FileMaker Custom Functions

FutureDate ( text )

Allow user to speedily enter dates using codes. Field must be text.

  Average rating: 4.3 (33 votes) Log in to vote

Jeff Yurka   Jeff Yurka
Real Mac Solutions
http://yurka.net

Share on Facebook Share on Twitter

  Sample input:
FutureDate ( d1 ) Assuming current date is 7/4/2006
  Sample output:
7/5/2006

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

Set a text field to a calculated value based upon this custom function, do not select "Do noter place existing value of field(if any). When the user enters d1 the date will automatically be one day after today, w2 will be 2 weeks after today, m3 will be 3 months after today and y4 will be 4 years after today. The codes can be entered in any order m1 or 1m for example

 

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.