Set analysis not working after data model change

[#1]

Hi,

I've changed my date format in the script from 'YYYYMM' to 'MM/YYYY'.

Now my set analysis is broken, at least it does not show anything:

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'))<=$(=date('$(vToday)'))"}>} Value)

Content of vFYStart is '01.04.2013', vFYEnd is '31.03.2014'

How do I have to change the expression to let it work again?

Thanks.

[MK_QSL · Accepted solution]

sum({$<Abschlusstermin.P= {">=$(=date('$(vFYStart)'),'MM/YYYY')<=$(=date('$(vToday)'),'MM/YYYY')"}>} Value)

[PrashantSangle]

Hi,

What is format of Abschlusstermin.P this field???

Regards

[#4]

'MM/YYYY'

[PrashantSangle]

Hi,

Then try manishkachhia expression ,It should work

Or You can also do one thing save vFYStart and vToday variable in that format .

Then it should Work

If Still not worked then Use

Date(Date#(vFYStart,'DD.MM.YYYY'),''MM/YYYY) and

Date(Date#(vToday,'DD.MM.YYYY'),''MM/YYYY) in above expression

Regards,

[SunilChauhan]

make vFyStart and  Vtoday variable in same format