Output To...

B

Brian

When I use the Output To command for either a query or a
table that contains a date field the format is 'medium
date'. I need it to be mm/dd/yyyy. Any suggestions?
 
D

Douglas J. Steele

Wrap a Format statement around your date field in the query, and export 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

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Publisher is filling blank lines with data 2
Converting Birth Date format 1
Forcing a date entry format of dd/mm/yyyy 1
Problem activating pre-installed MS Office home and Student 0
Date Maniplation 1

Top