Please Help

[#1]

Dear All

Please tell how to Make Logic with condition Mentioned Below

from  today's [current] date to last six month.

how can i write logic for this

Thanks In Advance!

Timba

[alexandros17]

I need more detail to help you,

you may use addmonths (Today(),-6) that return 2014/03/05

in this case you can set a condition where values are taken between the two dates

[#3]

Hi ,

Try Like this .

Expression

=sum({<trn_Date={'>=$(VarPrev6Maxdate)  <=$(VarMaxdate)'}>}  amount)

Variables

VarPrev6Maxdate : date(max(trn_Date),'DD-MM-YYYY')

VarMaxdate : Date(AddMonths(VarMaxdate,-6),'DD-MM-YYYY')

Thanks !!

[MayilVahanan]

Hi

Try like this

=sum({<DateField ={">=$(=Date(MonthStart(Max(DateField),-5),'DD-MM-YYYY'))  <=$(=date(max(DateField),'DD-MM-YYYY'))"}>}  amount)