I have a table contain user input [EXP Date] as varchar:
I am trying to convert them to date:
Convert(datetime, [EXP Date],101), but I got the error message:
Conversion failed when converting datetime from character string.
This issue have bothered me a long time and i tired walk around it, but this time I have to figure out something before I can move on to do some dates caculation.
Does any one have idea of this?
Thank you very much.