Test Data Manager

Expand all | Collapse all

How to generate unique random date in a specific format?

Jump to Best Answer
  • 1.  How to generate unique random date in a specific format?

    Posted 03-04-2017 10:11 AM

    Hi All,

     

    I want to generate the random unique date in a specific format for a DOB field.

    If i use, RANDDATE(MIN, MAX), will it always generate unique value or duplicate value might be generated?

     

    Please let me know how to generate unique random date in a specific format?

     

    Thank You.

    Regards,

    Rajasekhar



  • 2.  Re: How to generate unique random date in a specific format?
    Best Answer

    Posted 04-03-2017 03:41 PM

    Hi Rajaseknar,

    Why is a Unique Birthdate needed?  There are only 365 of those.  Are you also including the years?  Birthdates are not unique because of the limited dataset and in the real world, there are duplicates.

    Cheers!
    Les



  • 3.  Re: How to generate unique random date in a specific format?

    Posted 06-09-2017 12:27 AM

    Thanks Les for the update.