2 Replies Latest reply: Nov 11, 2016 9:10 PM by Bhawana Adhikari RSS

    How can we create dynamic expression for yearmonth field?

    Bhawana Adhikari

      Hi Everyone,

      I have a field fiscal year month that starts from 201301 to 201707 where 201301 is july 2013 since fiscal year starts from july and ends in June.

      I have a variable '$(vQC)'=If(getselectedcount(Month)=0,'201705',fiscal year month) where '201705' is nov 2017 which is a current month for my app since my app is forecast for 2017.

       

      What expression should I write in place of '201705' to make it dynamic?

       

      Thanks

      Bhawana