Convert Mon'YY to MM/DD/YY.

[Anonymous]

Hi All,

Convert Mon'YY  to MM/DD/YY.

Ex: April'15 to 04/01/15.

Thanks,

Krishna

Month
April'15
Aug'15
Dec'15
Feb'16
Jan'16
July'15
June'15
May'15
Nov'15
Oct'15
Sept'15

[#2]

Please check excel is this is the excel your getting because month is different formation

example:May'15

April'15

sept'15

there are the different formats in excel

if all are mmmyy formation then Kushal condition will work

[sunny_talwar]

Even if they are not the same, they can be forced to be MMMYY using the following set statement

SET MonthNames='Jan;Feb;Mar;April;May;June;July;Aug;Sept;Oct;Nov;Dec';

[Anonymous]

Thanks Sunny.