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

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.



Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: