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