Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 !!
Hi
Try like this
=sum({<DateField ={">=$(=Date(MonthStart(Max(DateField),-5),'DD-MM-YYYY')) <=$(=date(max(DateField),'DD-MM-YYYY'))"}>} amount)