BusinessHours ( )

Select when to send business email

Average rating: 4.8 (28 votes) Log in to vote

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

Sample input:

9/16/2013 4:17:21 PM

Sample output:

10/16/2013 8:00:00 AM

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)) ;

SendTime = Case( HourNow < HourStart ; GetAsTime( HourStart  & ":00" ) ;
	HourNow   ≥  HourEnd ; GetAsTime( HourStart & ":00" ) ;
	Get(CurrentTime)+ 600 );

SendDate = DayNow + Case(
	/* Filter Weekends ; days to add */
	DayOfWeek (DayNow ) = 1 ; 1 ;
	DayOfWeek (DayNow ) = 7 ; 2 ;
	hour( SendTime) = HourStart and DayOfWeek (DayNow ) = 6 ; 3 ;
	hour( SendTime) = HourStart ; 1 ;
	0 )
];
GetAsTimestamp( SendDate & " " & SendTime )
)

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.

Comments

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

BusinessHours ( )

Comments

Support this website.

Support this website.