DateValuesStrict ( dateBegin ; dateEnd )

Generate a return delimited list of date for the specified range.

Average rating: 4.5 (30 votes) Log in to vote

Jonathan Stark - Show more from this author
Jonathan Stark Consulting
http://jonathanstark.com/

Sample input:

DateValuesStrict ( "12/21/2005" ; "12/26/2005" )

Sample output:

12/21/2005
12/22/2005
12/23/2005
12/24/2005
12/25/2005
12/26/2005

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

Let ( [
    dateList = Case ( 
        Date Begin = "" ; "?"; 
        Date End = "" ; "?"; 
        not IsValid ( GetAsDate ( Date Begin ) ) ; "?"; 
        not IsValid ( GetAsDate ( Date End ) ) ; "?"; 
        GetAsDate ( Date Begin ) > GetAsDate ( Date End ) ; "?"; 
        Date Begin = Date End ; Date End & ¶; 
        Date Begin & ¶ & DateValuesStrict ( GetAsDate ( Date Begin ) + 1 ; GetAsDate ( Date End ) )
    );
    result = dateList
];
    result
 )

This is similar to the DateValues function, but it is strict. It requires both dates and dateBegin must be less than or equal to dateEnd.

Comments

		John Davis, Houston Aug 8, 2015
Your parameter names don't match your code. Here is the corrected code: Let ( [ dateList = Case ( dateBegin = "" ; "?"; dateEnd = "" ; "?"; not IsValid ( GetAsDate ( dateBegin ) ) ; "?"; not IsValid ( GetAsDate ( dateEnd ) ) ; "?"; GetAsDate ( dateBegin ) > GetAsDate ( dateEnd ) ; "?"; dateBegin = dateEnd ; dateEnd & Â¶; dateBegin & Â¶ & DateValuesStrict ( GetAsDate ( dateBegin ) + 1 ; GetAsDate ( dateEnd ) ) ); result = dateList ]; result )

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

DateValuesStrict ( dateBegin ; dateEnd )

Comments

Support this website.

Support this website.