WHERE
Something IN (115)
AND Something IN (1213)
AND Something = ‘I’
AND Something = ‘AC’

Instead of doing for Whole Month/Year
/* AND EXTRACT(YEAR FROM Something) = 2013
AND EXTRACT(MONTH FROM Something) IN (07)*/

I want to the Result set between these dates but this seems to be WRONG SYNTAX???????????

AND CAST(SOMETHING AS DATE) >= ’2013-07-23’

AND CAST(SOMETHING AS DATE) >= ’2013-07-29’

All help will greatly appreciated