Thanks steven. I see how you have incorporated date ranges in your query. However I do not understand how to incorporate this into my cube.

Do i create a Time dimension and then put a smiliar query to yours (using the date range) in the Time Dimensions "All Member Formula" in the dimensions property box?

or do you use a seperate interface to query your cube?