Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

BusinessHours ( )

Formatted output for nearest business day

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

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

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

// BusinessHours( ) /* Select when to send business email. If the time is not between 8am and 4pm then delay till next busines day If its the weekend then delay till Monday morning Default is to delay 10min before sending */ Let([ DayNow = Get(CurrentDate); HourStart = Hour( "8 am" ); // Business hours HourEnd = Hour( "4 pm" ); // Nobody really reads mail at the end of the day HourNow = Hour( Get(CurrentTime)) ; SendDate = DayNow + Case( HourNow ≥ HourEnd ; 1 ; /* Filter Weekends ; days to add */ DayOfWeek (DayNow ) = 1 ; 1 ; DayOfWeek (DayNow ) = 7 ; 2 ; 0 ); SendTime = Case( HourNow ≥ HourEnd ; GetAsTime( HourStart & ":00" ) ; Get(CurrentTime)+ 600 ) ]; GetAsTimestamp( SendDate & " " & SendTime ) ) Click to copy

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.

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: