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???
 
Top