Skip to Content
0
Former Member
Mar 28, 2009 at 06:41 AM

String to number and Number to String Problem!

33 Views

Hi All,

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.

Saravanakumar.