Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this:
sum({< vo_date_paid = {'>=$(#=(vCompareDate - 30))<=$(#=vPriorMonthEnd)'}>} vo_amt_net)
Try this:
sum({< vo_date_paid = {'>=$(#=(vCompareDate - 30))<=$(#=vPriorMonthEnd)'}>} vo_amt_net)
That worked! Thanks!
Hi Heathero, would you mind telling, in what format do you have your variables?
I was able to get this resolved. Thanks!
I know, is that i might be using what you finally got there. And i want to compare it to my proyect.
Here is how my variable was created.