UDF for Date format
I want to write an UDF
I want to pass Date as an String in format yyyymmdd.
I want to convert it to mm/dd/yyyy. & pass new date as o/p/
But there is a possibility that i/p Date may come as blank in that case I want to keep output as blank.
>>String month = Date.substring (4,2);
>>String day = Date.substring (6,2);
Index value is wrong. It should be (4,6) and (6,8).