date formatting issue in export file

[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

 

[Guest]

CVDate(Int([YourDateDate]))

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