Test Data Manager

  • Private Community
Back to discussions
Expand all | Collapse all

How to generate unique random date in a specific format?

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

    Posted Mar 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

    Broadcom Employee
    Posted Apr 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 Jun 09, 2017 12:27 AM

    Thanks Les for the update.