Thanks to both of you for looking into the matter.

Macro is working perfectly, as given by Solus.
Dear Jindon, the date is not being converted