SAPSETVARIABLE to pass the range

Hello Experts,

I have a requirement in the project to pass the variable for a query through the macro.

I am able to pass the single values to the query but my requirement is to pass the range i.e. From and To value to the query.

For example: i have calender year as variable and i want to pass 01012017 and 12312017 to that variable so that it gets me data between those dates.

Analysis Office - 2.4 version