Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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 - Show more from this author Real Mac Solutions http://yurka.net

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

/* The user can speedily enter future dates by using codes. Field must be a text field. d1 = today + 1 1d = today + 1 d7 = today + 7 w1 = today + 1 week 2w = today + 2 weeks m1 = today + 30 y1 = today + 365 */ Let([ TheType = Filter(Text;"dwmy"); TheLength = GetAsNumber(Text) ]; Case( TheType = "d" ; Get(CurrentDate) + (TheLength * 1); TheType = "w" ; Get(CurrentDate) + (TheLength * 7); TheType = "m" ; Get(CurrentDate) + (TheLength * 30); TheType = "y" ; Get(CurrentDate) + (TheLength * 365.25); Text ) ) Click to copy

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: