Date Range Parameters

I have data model for the existing report and user wants to have a date parameters where they can input a range of date which was linked in the column of creation_date.

I have tried this one,

select column1, column2, column3

from table

where column2 is between to_date(:date_from) and to_date(:date_to)

but I got error "Missing null keyword'

Do you guys have an idea how can I get this one?

Thanks in advance!