DateSurroundingDayNbr ( _Date ; _DayNbr )

Returns a surrounding Date according to the date entered and the Day Number to look for

Be the first to rate this function Log in to vote

StÃ©phane St-Pierre - Show more from this author

Sample input:

Date__Surrounding__DayNbr ( Date ( 5 ; 15 ; 2019 ) ; -1 ) or
Date__Surrounding__DayNbr ( Date ( 5 ; 15 ; 2019 ) ; 1 )

Sample output:

Date ( 5 ; 12 ; 2019 )
Date ( 5 ; 19 ; 2019 )

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

/*********************************************************************************
*
*  Params:  _Date ; _DayNbr [1..7] default to _Date
*
*  Return:  Date
*
*  Desc:    Returns a surrounding Date according to the _Date entered and by the 
*           Day Number to look for. Use negative _DayNbr to look past Date
*
*  Auteur:  Stéphane St-Pierre
*  Date:    16 mai 2019
*
********************************************************************************/



Let (
[
  Shift = If ( _DayNbr > 0 ; 
              Case ( DayOfWeek ( _Date ) = Abs ( _DayNbr ) ; 14 ; 7 ) ; 
              0 )
];
  Case ( Abs ( _DayNbr ) >= 1 And Abs ( _DayNbr ) <= 7 ;
  _Date - ( Mod ( ( DayOfWeek ( _Date ) - Abs ( _DayNbr ) ) - 1 ; 7 ) + 1 ) + Shift ;
  _Date )
)



/*******************************************************************************/

Returns a surrounding Date according to the date entered by the Day Number
to look for. Use negative _DayNbr to look past date

Comments

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

DateSurroundingDayNbr ( _Date ; _DayNbr )

Comments

Support this website.

Support this website.

Date__Surrounding__DayNbr ( _Date ; _DayNbr )

Comments

Support this website.

Support this website.

DateSurroundingDayNbr ( _Date ; _DayNbr )