Discussion Board for collaboration on QlikView Scripting.
I am using the following piece of code to calculate financial year
For example. This displays 2011 for any date between April 2011 and April 2012
However I would like the date to display: 2010/11, 2011/12, 2012/13 etc
I would appricate any help anyone has with this
Go to Solution.
you can use with Yearname(TempDate,0,4) as Fin_Yr.
It will give you the date field as 2011-2012,2010-2011..etc