convert date serial number, to mm/dd/yy?

  • Thread starter Thread starter wojo
  • Start date Start date
W

wojo

I imported an Excel worksheet into Access. The date was converted to a
serial number, but I need it to be displayed as a Date (MM/dd/yy). I
can't change the table, as it is 'linked'.

How can I import my worksheet and keep the dates intact?

Jo
 
1. Create a date/time field in your table. Save.

2. Create a query into the imported table.

3. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

4. Drag the new date/time field into the grid.

5. In the Update row under this field, enter:
CVDate([d])
where "d" represents the name of the date that shows as a number.

6. Run the query.

7. After verifying the results, you can dump the number field.

That should work unless you have dates prior to 1 March 1900.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert dd and mm and yy fields to one dd/mm/yy field 4
Change MM/DD/YYYY to MM/DD/YY 5
How to enter a date in DD-MM-YYYY format 2
change DD/MM/YY to MM/DD/YY 6
Change Field Format using VBA 2
change automatically from 051010 yymmdd to 10/10/05 mm/dd/yy 2
Dlookup 7
Matching on Dates & times 21

Back
Top