SQL & PL/SQL

Hi All

Can v use "Between" operator inside decode function.
Requirement is to get a value from the table by passing date(between passed date and last quarter date) and also match with a particular name.

Example:

select column1,column2,
decode(column3,'NAME',
decode(TO_DATE(column4),between to_date(sysdate) and add_months(to_date(sysdate),-3),1), 0) quarter_results from tablename;

this is the scenario am facing can somebody with a proper solution

Regards,
Naresh Kumar Murali