Set Analysis for Date between Date1 and Date2

[#1]

Hi Guys,

I need to calculate the sum, when Recog_Date is >Today AND <= QuarterEnd.

The line below is working

Sum( {<Recog_Date= { ">$(=Date(Today(),'DD/MM/YYYY')) <=30/06/2011"}>} RevenueProductYTD)

but when changing as follows I get a wrong result:

Sum( {<Recog_Date= {">$(=Date(Today(),'DD/MM/YYYY')) <= $(=Date(QuarterEnd(Today()),'DD/MM/YYYY'))"}>} RevenueProductYTD)

What's missing?

Thanks in advance,

Aldo.

[#2]

Normal 0 21 false false false DE X-NONE X-NONE MicrosoftInternetExplorer4

Hi,

in your example with the coded date you are 3 months ahead:

30/06/2011.

If you try your set-expression and you tried it on the posting date,

it won't get a result:

quarterEnd of 31/03/2011 is 31/03/2011. So you try:

>31/03/2011 and <= 31/03/2011..

HTH

[#3 · Accepted solution]

Hi,

I solved it as below:

{<

Recog_Date={">$(=Date(Today(),'DD/MM/YYYY')) <=$(=Date(QuarterEnd(Today())+1,'DD/MM/YYYY'))"}>} RevenueProductYTD

)

Thanks,

Aldo.