0
I'm embarrassed with a seemingly very simple problem. I have about 7 million of rows in Access, with a date column formatted as numbers. They are the 5 digit type of numbers excel uses when dates are formatted as numbers. How do I reformat them as dates?
For example, in access:
should look like (in Excel):
I tried using the built in date and time functions in Access to no avail. I can't simply move the database to Excel, reformat, then move on with my life due to the number of rows I'm using.
I wouldn't post this unless I thought other people would refer back to this and learn something.
wizlog
Posted 2016-07-28T21:06:07.453
Reputation: 12 320
I rarely use Access, but, in 2016, select a cell in that column. Then goto
Fields►Formatting►Data Typeand change the data type toDate/Time– Ron Rosenfeld – 2016-07-30T00:44:14.790Can you share table design view screenshot. – Adarsh – 2016-08-08T07:14:19.100
excel also uses the numbers. If you want to see the dates, format the column as Short Date in excel – SeanC – 2016-09-06T21:06:29.780