How to convert text to date
I have a text formatted line item which is a date .I want to convert it to Date format .
I tried to break it into three Year ,Month and day using
It works for 12/10/2012 but what about 2/3/2012 ??
Note -- Can't change source text to date format .