NextWorkDay ( YourDate )
Calculate next working date
Average rating: 4.0 (20 votes) Log in to vote
|
Dick Impens - Show more from this author
MaltaCode https://maltacode.com |
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, 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, 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 May 6, 2016 |
|
| Replace the Today with YourDate + 3 | ||
|
Lee Smith May 6, 2016 |
|
| oops, forget the + 3 Sorry. i.e. just change it to YourDate |
||
|
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, 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, MaltaCode May 10, 2016 |
|
| Hi Thomas, I know, but lost my password, got it back, so it's edited. | ||
|
Thomas Hellwig, Hamburg/Germany May 10, 2016 |
|
| Hi, Dick! So you don't have a FM-password database?! How can that be? ;-) |
||
|
Dick Impens, MaltaCode May 10, 2016 |
|
| Hi Thomas, can you create a password database in FM?.... Interesting ;) I thought Brian was the only one... :) | ||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.