Brian Dunning's FileMaker Custom Functions

NextWorkDay ( YourDate )

Calculate next working date

  Average rating: 4.0 (20 votes) Log in to vote

Dick Impens   Dick Impens
MaltaCode
https://maltacode.com

Share on Facebook Share on Twitter

  Sample input:
NextWorkDay (Get (CurrentDate) )
  Sample output:
9/05/2016

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

This function calculates the next working date on the given YourDate. The weekend will be skipped so if entered a Friday date the next working date will return the first Monday date.

 

Comments

Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 6, 2016
The function returns an error while creating it: "the parameter 'Today' does not exist".

I use FMPA 12.0v4.
 
Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 6, 2016
And please note:

Function Definition (the function itself):
Please use FileMaker's convention of one space between all terms and separators.
 
Lee Smith   Lee Smith
May 6, 2016
Replace the Today with YourDate + 3
 
Lee Smith   Lee Smith
May 6, 2016
oops, forget the + 3

Sorry.

i.e. just change it to YourDate
 
Dick Impens   Dick Impens, MaltaCode
May 8, 2016
Sorry, there is a typo made by me, the function should be;

YourDate +
Case(
DayOfWeek ( YourDate ) = 6; 3; //Fri
DayOfWeek ( YourDate ) = 7; 2; //Sat
1)
 
Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 10, 2016
You can edit the function text by clicking on the link above: "This is my Custom Function and I want to edit it"
 
Dick Impens   Dick Impens, MaltaCode
May 10, 2016
Hi Thomas, I know, but lost my password, got it back, so it's edited.
 
Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 10, 2016
Hi, Dick!

So you don't have a FM-password database?!

How can that be? ;-)
 
Dick Impens   Dick Impens, MaltaCode
May 10, 2016
Hi Thomas, can you create a password database in FM?.... Interesting ;) I thought Brian was the only one... :)
 

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.