Error in date range variable

Anonymous — Wed, 02 May 2018 08:21:01 GMT

Hi,

I have $TrendDate named variable, which im trying to use to filter a chart by date. Heres an example to what value I set the variable:

=>Date(Today()-7)<=Date(Today()) - which would mean select a weeks date range right? How ever, I get an expression error stating

"Garbage after expression 'Date'" here. What kind of syntax should I use here?

Here is how I use the variable in the chart expression:

Avg({$<Date={'$(TrendDate)'}>}[#Value])

// Tuomas

Re: Error in date range variable

sunny_talwar — Wed, 02 May 2018 16:50:45 GMT

Try the variable like this

='>' & Date(Today()-7) & '<=' & Date(Today())