date formatting issue in export file

L

Les Carlin

Hi

I'm use an access to create a text file which includes dates. The
file export to a .txt comma delimited file works ok, EXCEPT:

The date, when it appears in the text file also includes the time.
The Access (Office XP version) does not include a facility to strip
out the time, that i can see. Its essential that the text file
contains only a date.

If anyone knows a way to do this i would be very gratefu

Les
 
K

KARL DEWEY

CVDate(Int([YourDateDate]))

The "INT" removes any decimal fraction from the date.
 
Top