Brian Dunning's FileMaker Custom Functions

BusinessHours ( )

Formatted output for nearest business day

  Average rating: 4.5 (26 votes) Log in to vote

Roger Biel   Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Share on Facebook Share on Twitter

  Sample input:
  Sample output:
10/15/2014 8:00 AM

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

I routinely send business email such as invoices, proposals, and reports directly from FileMaker and wanted to delay delivery until normal business hours.
Only thing missing from this is holidays.

Nobody really reads mail at the end of the day so developed this function to schedule Emil on the next business day for my invoices.

It also delays sending the email for 10 min, allowing me to add a comment or additional information to the email.

 

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.