I created a function to generate a random date, like this:
create or replace function F_GENERATE_RND_DATE(
starting_date in Varchar2 Default to_char(Sysdate-30,'ddmmyyyy'),
ending_date in Varchar2 Default to_char(Sysdate,'ddmmyyyy')) return varchar2 Is
Result...