Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Maybe it is very simple but i couldnt get the answer for more than 2 days.
sample data are like this
Date amount
2011-01-01 100
2011-01-02 200
2011-01-03 300
2015-01-05 400
2015-02-01 500
2015-03-01 600
I want get data from date range 2011-01-03~2015-02-01
2011-01-03 is getting from input box variable vDateFrom and 2015-02-01 from input box variable vDateTo.
Two variables numbur format is date(YYYY-MM-DD)
I used set operation
Sum( {<Date={">= $(vDateFrom) <=$(vDateTo)"} amount)
Expecting answer is 1200 of course but the result is null.
The curious thing is that if the table of Date type is 'YYYYMMDD' and varialbe number type is number(not date 'YYYY-MM-DD') then I could get the epected result.
Please show me the answer.
Thank you.
Sum( {<Date={">= $(=date(vDateFrom)) <=$(=date(vDateTo))"} amount)