| | |
|
|
|
Exporting txt files |
|---|
| message from len on 6 May 2004 |
I am having an issue with exporting a date field to text.
The date field in access is set to mm/dd/yyyy but that is
for display only. when exporting the date I get the date
and time.
How can I export only the date. mm/dd/yyyy?
|
| Cheryl Fischer replied to len on 6 May 2004 |
You could create a Query of your data and export from that. In your query,
JustDate: DateValue([MyDateTimeField])
|
| Pieter Wijnen replied to len on 6 May 2004 |
Either create a query to typecast the field using DatePart or Format for the
export - or -
create a export spec & set the date format (advanced) & use that when
exporting
HTH
Pieter
"len" <anonymous@discussions.microsoft.com> wrote in message
news:959401c4337b$3285a5b0$a301280a@phx.gbl...
|
| len replied to Pieter Wijnen on 6 May 2004 |
I used this method
create a export spec & set the date format (advanced) &
use that when exporting..
I still get the time include in my date, could I be doing
something wrong?
DatePart or Format for the
use that when
message
text.
date
|
| cpv replied to len on 6 May 2004 |
You can use a query and format the field
Format([YourDateField],"MM/DD/YYYY")
len <anonymous@discussions.microsoft.com> wrote in message
news:959401c4337b$3285a5b0$a301280a@phx.gbl...
|
|
Archived message: Exporting txt files (MS Access Error Message)
