I kept @odate as today() - 8days

and @Fromdate as "= Iif(Month(today())>04, "04/01/"&Year(Today()),Iif(Month(today())<= 04, "04/01/"&(Year(Today())-1),1))"

i wrote this query to fetch from april of last year.

i.e if i run today (year is 2014).It should automatically fetch from last year (april 2013)

i don't know how to proceed to for weekwise