Forcing Date format as output?

  • Thread starter Thread starter S Davis
  • Start date Start date
S

S Davis

Hello,

Is there any way to create a query in access such that when imported
through the use of MS-Query in excel, it comes in as a recognized date
and not text?

I have tried FormatDateTime ([Column],2) and Format
([Column],"d-Mmm-YYYY"). Both return acceptable visual representation
of my data, but are seen as text in excel and are preventing me from
Grouping my pivottable data.

Thanks
-Sean
 
By definition, the Format function outputs a string. What happens if you
don't format it at all in the query?
 

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

Dates as column names export to excel as text 5
Date format in a report 2
Text to date format? 0
Excel How to change the "Short Date" format in Excel? 4
Date format when exporting 2
Access General Date Forced To Have Date And Time 2
Ordering of Dates when formatted in a query 2
Date query 4

Back
Top