How to convert string to a date

  • Thread starter Thread starter galsaba
  • Start date Start date
G

galsaba

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
 
For the first 2 dates, use:

=--(MID(A1,4,2)&"-"&RIGHT(A1,2)&"-"&MID(A1,2,2))

By the way, 2/30/2001 is not a real date and the formula
will produce an error.

HTH
Jason
Atlanta, GA
 
Back
Top