Wednesday, October 26, 2011

Display Date in two digit Excel to mySQL

=YEAR(L5)&"-"&IF(LEN(MONTH(L5)) = 1,CONCATENATE("0",MONTH(L5)),CONCATENATE("",MONTH(L5)))&"-"&IF(LEN(DAY(L5)) = 1,CONCATENATE("0",DAY(L5)),CONCATENATE("",DAY(L5)))

No comments:

Post a Comment