RandomDate

creates a random date between the specified first and last dates, inclusive

Average rating: 4.6 (21 votes) Log in to vote

Jeff Drake - Show more from this author
Drakeling Technologies

Sample input:

RandomDate (

Date ( 1 ; 1 ; 2015 ) ;

Date ( 9 ; 4 ; 2015 )

)

Sample output:

4/6/2015

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

/*
=======================================================
    RandomDate ©2015 Drakeling Technologies
    Created 9/4/2015 by Jeff Drake

    This function creates a random date between the specified first and last dates, inclusive, e.g.
    • RandomDate ( Date ( 1 ; 1 ; 2015 ) ; Date ( 9 ; 4 ; 2015 ) ) = 8/3/2015
    • RandomDate ( Date ( 1 ; 1 ; 2015 ) ; Date ( 9 ; 4 ; 2015 ) ) = 4/6/2015
    • RandomDate ( Date ( 1 ; 1 ; 2015 ) ; Date ( 9 ; 4 ; 2015 ) ) = 7/4/2015

    Dependencies: none
=======================================================
*/


Let ( #days = dateLast - dateFirst + 1 ;

   Max (

      dateFirst ; //JUST IN CASE THE RANDOM NUMBER IS EXACTLY 0


      GetAsDate (

         Ceiling ( #days * Random ) + dateFirst - 1

      ) //end GetAsDate

   ) //end Max

) //end Let

This function is designed to aid in creating “dummy” data for your FileMaker Pro database. For example, you can specify a calculation in the “Calculated value” dialog under field options and have a random date entered into each new record.

Comments

		unin, Japan Sep 10, 2015
dateFirst + Int ( Random * ( dateLast - dateFirst + 1 ) ) Using Int() for Random is the programming pattern.

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

RandomDate

Comments

Support this website.

Support this website.