Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want to show sum the values falling between two dates in a textbox . Below are the steps which i followed so far
=Sum({$<closeDate = {">=$(venddate) <=$(vEndDate) "}>} sales)
Can anyone help me on to correct the syntax
Many thanks
Ashish
How do your closeDate field values look like? What is the format of your field?
And how do your variables look like when dollar sign expanded (you can check this e.g. by using text boxes)?
below is the screen shot of variables
and if i use them directly in text box like below
=$(vstartdate)
=$(venddate)
it shows the correct date
Try this
=Sum({$<closeDate = {">=$(venddate) , <=$(vEndDate) "}>} sales)
or this
=Sum({$<closeDate = {">=$(venddate)"}, closeDate={"<=$(vEndDate) "}>} sales)
Your QV functions need to be interpreted before passing to the search string, try
=Sum({$<closeDate = {">=$(=vstartdate)<=$(=venddate) "}>} sales)
i tried it but showing me zero in return
=Sum({$<closeDate = {">=$(vstartdate) , <=$(vEndDate) "}>} sales)
its returning 0 as output
What is the date format in closeDate Field? Does the date format in closeDate field matches the Date format of your variables?
Ok,
try using the orginal version:
Your QV functions need to be interpreted before passing to the search string, try
=Sum({$<closeDate = {">=$(vstartdate)<=$(venddate) "}>} sales)
But define your variables with a preceding equal sign:
=today()
=makedate(2012,1,1)