Hi.
I have been reading User's Guide and I have discover this for Random function of Data Generator:
"Random([Min], Max) Returns random numbers between Min and Max. If only Max is specified, Min is set to 0. For date fields you can enter dates for Min and Max."
But I am missing something because I have tried several ways for setting min and max value of the date and nothing works for me.
I have tried:
- Random('01/01/2016','01/05/2016')
- Random(date '2016-01-01', date '2016-05-01')
- Random((to_date('01/01/2016','DD/MM/YYYY'),to_date('01/05/2016','DD/MM/YYYY'))
- Random(SQL(to_date('01/01/2016','DD/MM/YYYY')),SQL(to_date('01/05/2016','DD/MM/YYYY')))
Can anyone help me? How can I set min and max value for a date in Random function?
Regards.
Last edited by ifernan; 05/05/16 04:11 PM.