Text to Date type
Posted on 2002-07-15
I have a text field “EndDate” in my table, half of data have format: mm/dd/yy the rest dd-MMM
I want to convert all data from text to date type format: mm/dd/yy.
Data in this field are like :
I want to put year 2001(01) at the end where it missing and then convert all data to date type.
May data in “EndDate “should look like :