Set analysis with date limitation

[#1]

Hi,

I had a working set analysis expression that limited the date from the start of the fiscal year until today:

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'),'YYYYMM')<=$(=date('$(vToday)'),'YYYYMM')"}>} [TCV Reportet (Produkt).P])

After a while and several changes to the scripts and the front end, I figured out that the limitation is not working anymore, so it shows all TCV values, not only from FY start to today.

Not sure if this is related to this change: the format for 'Abschlusstermin.P' in the load from was 'YYYYMM', now it's 'MM/YYYY'. I changed the expression to be

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'),'MM/YYYY')<=$(=date('$(vToday)'),'MM/YYYY')"}>} [TCV Reportet (Produkt).P])

, but this won't work. Any ideas what is going wrong?

Thanks.

[#2]

This is working fine for the target values, what about the TCV stuff above? It seems that if I add the '=' sign, it calculates for the whole June, but I only need everything until vToday ('06.06.2014').

[CELAMBARASAN]

Then it needs date field, not possible with Year month field. Here you can't decide the data that falls up to today.

May be the below will help you

YTQ, QTD, MTD and WTD

[#4]

You need a date field, not just MMYYYY, to accomplish what you want.

[#5]

I have a date field, too, called SERVICE_DATE.

[CELAMBARASAN]

Then try this

sum({$<Abschlusstermin.P=, SERVICE_DATE= {">=$(=date('$(vFYStart)'),'DD/MM/YYYY')<=$(=date('$(vToday)'),'DD/MM/YYYY')"}>} [TCV Reportet (Produkt).P])

Where 'DD/MM/YYYY' this format should be same as the SERVICE_DATE field date format.