start date and end variable

[Ayden]

how can i create start and End date variable to use in set analysis 

thanks ahead 

[rubenmarin · Accepted solution]

Hi, this can be done in many different ways based on the model and the needs, one option is to create a vMinDate and vMaxDate variables with this values:

vMinDate -> Min(DateField)

vMaxDate -> Max(DateField)

And used like: Sum({<DateField={">=$(vMinDate)<=$(vMaxDate)"}>} Sales)

[Ayden]

thanks a lot