between data?

[Anonymous]

Hi  i have fields called

date,date2

date:

1/1/2014

2/1/2014

3/1/2014

4/1/2014

5/1/2014

6/1/2014

7/1/2014

8/1/2014

9/1/2014

10/1/2014

11/1/2014

date2 is like calendar object when i enter   date2 =3 and selected  date is  5/1/2014

i want see result   for

4/1/2014,

3/1/2014,

2/1/2014,

pls give me expr for this ?

[sushil353]

hi,

the expression could be:

sum({<Date={">= $(=Date(Max(Date)-3)) <$(=Max(Date))"}>}sales)

HTH

Sushil

[Anonymous]

its for static if  date2 may change like 1 ,5 ,7  ....

what i have to put instead of 3 for dynamic

[Anonymous]

and eventhough u r telling max(date) but i dont want select max(date) always

in between if i select any date it should work for that date

as per ur exp its always take max(date)

[sushil353 · Accepted solution]

Hi,

If you are assigning date2 in some input box then that variable you can use in your expression in place of 3

sum({<Date={">= $(=Date(Max(Date)-vDate2)) <$(=Max(Date))"}>}sales)

and Max(Date) will get the max date of your selection..

HTH

Sushil