Date Range in Set Analysis

[#1]

Need to be able to expand the date range. How do you do a between clause. I would like to make it a 3 month sum

sum({ $<Forecast_CloseDate={[05-2011]}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Thanx

[#2 · Accepted solution]

You would handle it just like you handled your Forecast_Probability range:

sum({ $<Forecast_CloseDate={'>05-2011<08-2011'}, 
 Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Keep an eye on those date formats though. If your format doesn't match up correctly, the expression would probably return null.

[#3]

totally worked. Thank you!