I have a string field that some values are formatted as 01/01/2000 and some are formatted as 01012000. There is also the occassional blank and occasional text like "unknown".
I need to skip the blanks and occasional text and format everything as as a date in the 01/01/2000 format.
I don't know where to start - Ive done a ton of googling, but haven't gotten far...can someone please help me??
Appreciative,
Kelly
Edited by kellyjean621 - 16 Jan 2013 at 3:21am