Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Date format when exporting
1 view
Skip to first unread message
mike
Nov 10, 2009, 10:23:20 PM11/10/09
to
The date format of my query export to csv keeps howing as mm/dd/yyyy 0:00. I
only want to show mm/dd/yyyy.
only want to show mm/dd/yyyy.
My regional settings are set to short date as are the fields in the import
table and query.
Help!!!
Tom van Stiphout
Nov 10, 2009, 10:43:30 PM11/10/09
to
On Tue, 10 Nov 2009 19:23:20 -0800, mike
<mi...@discussions.microsoft.com> wrote:
<mi...@discussions.microsoft.com> wrote:
You are probably trying to export a table. Export a query instead,
which you will have properly formatted.
-Tom.
Microsoft Access MVP
John W. Vinson
Nov 10, 2009, 11:51:47 PM11/10/09
to
On Tue, 10 Nov 2009 19:23:20 -0800, mike <mi...@discussions.microsoft.com>
wrote:
wrote:
>The date format of my query export to csv keeps howing as mm/dd/yyyy 0:00. I
Exports ignore the table (or query, sorry Tom) formatting. But you can use the
Format() function in a query to explicitly cast the date value as a string.
Create a query based on the table; omit the date/time field; instead put in a
calculated field
ExpDate: Format([datefield], "mm/dd/yyyy")
--
John W. Vinson [MVP]
0 new messages