How can I change the Date Format in Access 2000 from (20010119) to 1/19/2001 without touching every date.
I have about 65,000 dates with this format and it's not easy to read. These are in a column called Date_Received.
These were pulled from another database and imported somehow to Access. I could even email a partial file to someone for example if needed. I have tried using the design view to change the format to dates, but had no luck.
Any suggestions to post this else-where?
I have about 65,000 dates with this format and it's not easy to read. These are in a column called Date_Received.
These were pulled from another database and imported somehow to Access. I could even email a partial file to someone for example if needed. I have tried using the design view to change the format to dates, but had no luck.
Any suggestions to post this else-where?