Comparing Date between Two dates

Example: to_date(AUTHORIZEDTIME,'mm/dd/YYYY HH12:MI:SS AM') between to_date('" + fromdate + "','dd/mm/yyyy') and to_date('" + tilldate + "','dd/mm/yyyy') ORDER BY dateorder DESC


Syntax: to_date(Fieldname,'Date Format')  between to_date(Fieldname,'Date Format') and to_date(Fieldname,'Date Format')