Chart display on date range condition

[#1]

Hello:

How can I customize my Dimension statement to display only value in the previous month?

I tried

=

IF(max(date(Mydate)) >=monthstart(today(),-1) AND max(date(Mydate)) <= monthend(today(),-1),SomeNames)

but its not working I'd really appreciate any help with this.

Thanks

AO

[vupen]

QV has a month function that can be used:

If(Month(Mydate) = Month(Today())-1,SomeNames)

The "-1" in the later part is to get the previous month.