to produce reports created within 2 dates

Hello,
I need a code to print all the reports which are created betweeen 2 dates . How can i do it? I found the difference (interval) between the 2 dates and then used the following code

select * from table_name where (created_date, interval '$interval' day) >'$created_from';

But when this code is executed, sometimes the reports which are not created in this interval is also shown.

What could be done? Could u please help.

Thanks in advance.

I forgot to mention that my code is in perl and i am using mysql database

Thank u
Dups