Set Analysis Between Dates

[Anonymous]

I'm trying to find the values between two dates using variables.  I would like to show everything between vCompareDate and vPriorMonthEnd but this is giving me data outside that date range.  Any ideas?

sum({< vo_date_paid = {'>=$(#=vCompareDate - 30)'}, vo_date_paid = {'<=$(#=vPriorMonthEnd)'}>} vo_amt_net)

[#2 · Accepted solution]

Try this:

sum({< vo_date_paid = {'>=$(#=(vCompareDate - 30))<=$(#=vPriorMonthEnd)'}>} vo_amt_net)

[Anonymous]

That worked! Thanks!

[#4]

Hi Heathero, would you mind telling, in what format do you have your variables?

[Anonymous]

I was able to get this resolved. Thanks!

[#6]

I know, is that i might be using what you finally got there. And i want to compare it to my proyect.

[Anonymous]

Here is how my variable was created.