<div>
It is a date field in access, when it comes into the worksheet, it is formatted as a general number. &nbsp;If I format the worksheet column to a date, it puts it in as a date, but I want it to come into the worksheet as a formatted date. &nbsp;I'll try the Cdate and get back to you tomorrow when I go back into work. &nbsp;Thanks for the quick response.
</div>


<div>
<div class="content wysiwyg-content">
I have an excel macro that is pulling data from an access query, but my result fields that are dates that are going into an excel worksheet &nbsp;are coming in as a number and not a date. &nbsp;What syntax do you use to format the field in the vba select statement? &nbsp;Example field name IDWS.Date_On
</div>
</div>


I have an excel macro that is pulling data from an access query, but my result fields that are dates that are going into an excel worksheet  are coming in as a number and not a date.  What syntax do you use to format the field in the vba select statement?  Example field name IDWS.Date_On

Formatting a date field in an excel macro

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.