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
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