Example: I'm pulling data for burglaries from 1/1/2013 - 3/31/2013 using this running total.

 

{lwchrg.ucr_code}="220" AND {lwmain.zone} IN ["Z1","Z2","Z3","Z4","Z5","Z6","Z7","Z8"]AND
{lwmain.date_rept}>={?START DATE} AND {lwmain.date_rept}<={?END DATE}

 

Works good. No problem there but now I need to pull all the buglaries from the same 1/1 - 3/31 range but from 2012. I created another running total and tried this formula but it's not working.

 

{lwchrg.ucr_code}="220" AND {lwmain.zone} IN ["Z1","Z2","Z3","Z4","Z5","Z6","Z7","Z8"] AND
{lwmain.date_rept} >= DATEADD("yyyy",-DATEDIFF("yyyy",{?START DATE},{?END DATE}),{?START DATE}) AND
{lwmain.date_rept}<= {?START DATE}

 

Help please!

Thanks!

{lwmain.date_rept}>={?START DATE}
AND
{lwmain.date_rept}<={?END DATE}
So I guess it is excluding the data that are not within my parameter dates. Any idea how I fix this?

Thanks for your help!