Date Variable

[WhoaNelly]

How do I write a query that only returns data if the transaction took place in the last 10 months? It needs to be a 'rolling' 10 months as I don't want to come back in here and redo it every month.


TIA

 

[kdemulder]

I think the best way to achieve this is by creating a view on the database and adding a filter on there to say they only have to take the last 10 months.

 

[WhoaNelly]

I would do that, but then the client machine would freeze b/c it's such a large amount of data.

Thank you

 

[MDXer]

it really depends on how the data should appear to the front end user you can create a Calculated member which will some up the Past 10 months into a single value or you can create a Calculated set. Within the calculation you can use a filter where the date is between today minus 10 Time.Months.CurrentMember and Time.Months.CurrentMember - 10 this is done easier if you carry member properties with a unique Identifier from each Month Year set so todays month may be 33 and 10 months ago would be 23.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck