Date Formatting Question

[BLT1976]

I have searched past questions and could not find any answers to the following. When we imported data from another Dbase (not Access) into our Access DB, the date field came out "yyyymmdd". I have added "0000/00/00" to the input mask which provides it the necessary "/". However, I really need the information to read "mm/dd/yyyy".

The field in the main table is currently text. When I switch to Date/Time and try to ask it to format as "Short Date", it deletes all the Date of Births in that field.

Any suggestions on how I can convert this data?

Brandon

 

[glynch]

This seems clumsy but it should work:

CDate(Mid(YourDateValue,5,2) & "/" & Mid(YourDateValue,7,2) & "/" & Left(YourDateValue,4))

To use this ALL of the values must come in in the yyyymmdd format.

HTH

 

[BLT1976]

THANKS!

I don't care that it's CLUMSY, it WORKED! Thanks a bunch.

Brandon