Database Queries/Date Formats

[daver676]

I am importing columns from an Access table using MS
Database Query. The date format in the database is YYMMDD,
so the query brings the date into the spreadsheet as the
same. (ex. 880321). When I attempt to format the cells as
a date in Excel, the formatting doesn't work, and the date
stays in the same format. Why? And how can I get around it
using Excel? Thanks.

Dave

 

[Phobos]

Check the Access table, is the Date field set to a Date/Time datatype?

My guess is not. You can remedy this in Excel or in Access with a date
formula.

P

 

[Debra Dalgleish]

In Excel, you can use Text to Columns:

1. Select the column with dates
2. Choose Data>Text to Columns
3. Click Next, click Next
4. In step 3, choose YMD from the Date dropdown.
5. Click Finish.