Formula in MS Query

  • Thread starter Thread starter Krish
  • Start date Start date
K

Krish

I am trying to import external data into Excel spreadsheet. One of the
tables in the external data has a field "Time" for Date and time of
transaction. In MS query I inserted a new column with a new name and
inserted a formula Left(Filename.Time,11). The result came as "Dec 2,2003",
whereas I wanted this to show as "12/02/2003", in the true date format..
What function I should use to get the desired result from MS Query.

Thank you all for the help.

Krish
 
You could import the Time field in its Date/Time format, then reformat
the column in Excel
(Format>Cells, Number tab -- Date category)
 

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

MS Query will not start from Excel 2000 17
MS Query and date format 3
Formula for Latest Entry For Each Month 4
Date Comparison Formula 1
Excel Query setup 0
Specifying filtering criteria for ms query in excel 1
formula required (2nd time) 6
MS Query 1

Back
Top