date range not working

[#1]

Hi

I've been using the following in set analysis to give me the last 12 months so May 2012 to April 2013, but for some reason records for May 2013 are being included???

Can anyone help?

Thanks

count

({$<DateRaised={">=$(=addmonths(monthstart(today()),-12)) 00:00:00 <=$(=Monthname)today(),-1) 00:00:00"

}

[m_woolf]

You need addmonths for the second date expression as well.

[#3]

I've done that but unfortuately it hasnt worked!

count

({$<DateRaised={">=$(=addmonths(monthstart(today()),-12)) 00:00:00 <=$(=addmonths(Monthname)today()),-1) 00:00:00"

}