Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get the minimum and maximum selected values from a list box?
I have a list box filled with dates. I want to find the minimum date selected and the maximum date selected. Here is an example
Let us say I have 10 selected dates.
1/5/2012
1/6/2012
1/7/2012
1/8/2012
1/9/2012
1/26/2012
1/27/2012
1/28/2012
1/29/2012
1/30/2012
I want to get 1/5/2012 for my minimum and 1/30/2012 for my maximum.
Second part. What would the expression look if I wanted to sum a field for all the days between my minimum and maximum range of selected dates? So between 1/5/2012 AND 1/30/2012.
Thanks in advance
HI
=sum({<Date = {'>=$(=vMin)<=$(=vMax)'}>}Sales)
where vMin = Min(Date)
vMax = Max(Date)
Hope it helps