17 Replies Latest reply: May 19, 2016 5:45 PM by John Witherspoon RSS

    How to Generate random dates between a Start Date and End Date variables?

    Michael Wallman

      Hello all,

       

      I have two variables where users can input a start date and end date.

       

      Let's called it:

       

      vStartDate

      vEndDate

       

      Then I may have a table like this:

       

      Payments:

      LOAD

      PaymentID,

      <Create payment date based on vStartDatr and vEndDate here> PaymentDate,

      CustomerID,

      ProductID

      AutoGenerate 300;

       

      How can I get the PaymentDate to have a date randomly generated from the vStartDate and vEndDate?