Discussion Board for collaboration related to QlikView App Development.
I am selecting a month (ex- Sep 13) from list box. I have text box where in I want to display Oct 12 as output.
Any idea how to do that.
I tried with the following
But, it doesnt work. It throws Sep 12. Here Month is a field in table having values like May 13, June 13 etc..
If you want output in MMM YY format
Date(AddMonths(Date#(YourField,'MMM YY'),-11),'MMM YY')
View solution in original post
use AddYears(Date#(YourField,'MMM YY'),-1)
Thanks mate..it works..
=Date(Addmonths(date#([Your field]),-11),'MMM YY')