In my report i ahve to display the Date.
From DB i am getting 4 digit string( 2008). Using that i have to display as 08 - 09
In that i used RIGHT function. it is diplayed as 08 - 9.
when i take 2 character from right '08' is coming. Then i converted to number and added 1 to the year
But it become 9 instead of 09.
How to solve it.
Thanks in advance.