Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know there are many examples of this on the forums, but can't get it to work in my enviroment
Simple, trying to sum Dollars based on input box variables...the field is Month|Year
vTY_Start and vTY_End
A sample value here is 01-2013
This is what i'm trying, but doesnt seem to work.
Sum({<Month|Year={'>=$(vTY_Start)<=$(vTY_End)'}>} Dollars)
Thank you in advance!
-David
Some possible problems:
01-2013 could be evaluated as 1 - 2013 = -2012
Month|Year contains text values and comparing text values using >= and <= won't work
Month|Year is a date field formatted as MM-YYYY, but the variables vTY_Start and vTY_End are string values. You'll need to use the date# function to make dates from them: date#(vTY_Start,'MM-YYYY')