How to set date filters in a portlet

AND TRUNC(a.creation_date) = to_date(SUBSTR('[P.CREATED_ON]',1,10), 'YYYY-MM-DD' )

This results in ability to filter portlets by date