Converting Date Format from YYYY-MM-DD to Access date format

A

activegirl

Hi,

I'm downloading some data from a data repository. The dates in the
repository are formatted as YYYY-MM-DD, for example 2004-05-18. When I
import the data into excel if I choose date/time format, then the fields do
not import. How can I convert this field to the access date format of
05/18/04?
 
K

Ken Snell [MVP]

You can convert using the Format function:

Format(DataRepositoryDateString, "mm/dd/yyyy")
 
V

Van T. Dinh

In the Import Text Wizard dialog, there is an "Advanced" button. Click this
button and select the suitable date format to import.

This assumes you want to import into Access. The Subject implies Access but
the body of the post says Excel???
 

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

VBA - exporting serial letters to single documents 0
Date Formats 4
Forcing a date entry format of dd/mm/yyyy 1
printing report with date 2
Converting Birth Date format 1
How to enter a date in DD-MM-YYYY format 2
Publisher is filling blank lines with data 2
Change MM/DD/YYYY to MM/DD/YY 5

Top