Exporting txt files

  • Thread starter Thread starter len
  • Start date Start date
L

len

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?
 
You could create a Query of your data and export from that. In your query,
to get just the date portion of your date/time field, use the DateValue()
function:

JustDate: DateValue([MyDateTimeField])
 
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
 
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?
 
Back
Top