Convert Date to Text for Export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am having problems attempting to export a date field out of a query.

I need the date to be exported surrounded in quotations like so in notepad
"27/03/1982"

However, Access only exports dates as they are, and with 00:00:00 added.
eg - 27/03/1982 00:00:00

How can i export the date so it looks like a date still - ie - not short
date format, and surrounded by quotes?

Thnks for any help in advance,

Peter
 
Add this column to a query:

ExportDate: '"' & Format$([DateField],"dd/mm/yyyy") & '"'

where DateField is your date field's name and the leading and trail quotes
are like:

single-quote double-quote single-quote
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 

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

Additional value is added to date value or time value after exportingaccess data to text format 2
Date format when exporting 2
Date & time Data Type formatting 1
Simple Methods to Export Gmail to Text? 1
Help Exporting DATE values 6
date format problems with export to csv 1
Export a date field without the time (access 2003 & 2007) 1
mm/dd/yyyy format 9

Back
Top