Date Help -2

[Anonymous]

Hi All,

I have created an variable called "vDate" for "My_Date" field and wonder if it's possible to select multiple dates via an InputBox and Date Slider? For the Slider, i couldn't even populate the date data via variable selected.  Attached sample QVW. 

Any Input greately appreciated!

Thanks,

Frank

[sunny_talwar · Accepted solution]

Try this:

RangeSum(

Sum({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount) + Avg({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>}1000),

Sum({<My_Date -= {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount))

[Anonymous]

Thanks Sunny.  Not sure how "AVG()" plays a role in this RangSum..

[sunny_talwar]

Just so we can use the set analysis to add 1000 to just the selected range. You can replace it with Only()