restricting date field

[ssriramin19]

Hello.

   My requiement is that I am having date field which contains june 2012 to may 2013 dates. But I want only from june 2012 to nov 2012 which is 6 months data . This I want to be done in front end itself .

Can anyone tell me how to implement the above logic in front end itself.

It is very urgent .

Thanks

Sriram

[MayilVahanan]

HI

Try like this

=sum({<Date = {'>=$(=Monthstart(AddMonths(today(),-6)))<=$(=MonthEnd(AddMonths(Today(),-1)))'}>}Sales)

Hope it helps