I need to do few conversion.
the date in a date field is a string data of this format:
1010230 which indicates 02/30/2001 (101 is 2001)
1051215 indicates 12/15/2005.
How can I convert one to the other?

Also I have
1010230 that I want to convert to a string of YYYYMMDD

and string YYYYMMDD that I want to convert to date format MM/DD/YY

Thanks,

galsaba