<div>
<div class="content wysiwyg-content">
I am exporting a query result to an Excel file. &nbsp;The query contains a date field. &nbsp;The date field is Short Date by default. &nbsp;But when for example 3/14/2017 gets exported to the Excel file it looks like 3/14/2017 &nbsp;12:00:00 AM<br />
<br />
Why is this happening?<br />
<br />
The export VBS code is:<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29074402-1"><span>DoCmd.TransferText acExportDelim, , &quot;qryRecords&quot;, strCSV &amp; Environ(&quot;userProfile&quot;) &amp; &quot;\Desktop\&quot; &amp; &quot;Records &quot; &amp; Format(Now, &quot;mm-dd-yyyy_hh-nn&quot;) &amp; &quot;.csv&quot;, True</span>
</code></pre>
</div>
</div>


I am exporting a query result to an Excel file.  The query contains a date field.  The date field is Short Date by default.  But when for example 3/14/2017 gets exported to the Excel file it looks like 3/14/2017  12:00:00 AM

Why is this happening?

The export VBS code is:

(CODE)

Export date field via a query to an Excel file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.