Choose 2 Dates to get the data.

[#1]

Hello Everyone,

I have two variables vThisMonth = 06/15/2014;

and vLastSixmonth = Addmonths('$(vThisMonth)',-6);

I want to create a chart where expression shows max(Score) between there two variables in other words between last 6 months, I've tried :

     max({<Date = {">=$(vThisMonth)<=$(vLastSixmonth)"}>}Score)

However, the data is not displayed correctly, any ideas?

Thanks in advance.

[vgutkovsky]

Do you mean your vThisMonth variable is literally hardcoded to "=06/15/2014"? If so, QV doesn't understand that that's a date. Try =date#('06/15/2014')

Regards,

Vlad

[#3]

Thanks Vlad,

no, vThisMonth is being dynamically created by resident loading of max(date) from one of the table.

[vgutkovsky · Accepted solution]

Oh, wait a second, just noticed that your condition is reversed Flip your <= and >= signs.

Regards,

Vlad