DatePlusMinus ( datefield ; internal param )

Enters current date, subtracts a day or adds a day

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

Steve Gerow - Show more from this author
Abrazos Data Consulting
http://www.abrazosdata.com

Sample input:

Plus button:

Minus button:

Sample output:

If blank, Current Date; if date exists, add one day.
If blank, Current Date; if date exists, subtract one day.

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

// DatePlusMinus [datefield ; internal param] =
// internal param allows equivalent of Script Param to be used in Set Field via Plus & Minus buttons
// if empty Current Date is set by either Plus or Minus

If ( IsEmpty ( datefield ) ; Get ( CurrentDate ) ;
Case ( internal param = "-" ; datefield - 1;
Case ( internal param = "+" ; datefield + 1 )))

Use for setting a date field with Plus and Minus buttons.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

DatePlusMinus ( datefield ; internal param )

Comments

Support this website.

Support this website.