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 - Show more from this author
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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 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:

Under construction. Email me your wish list for improvements.