Exporting txt files

[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?

 

[Cheryl Fischer]

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])

 

[Pieter Wijnen]

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]

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?

 

[cpv]

You can use a query and format the field
Format([YourDateField],"MM/DD/YYYY")