How to export Data/Time data to a text file without 0:00:00

[qwang1115]

I tried to export the date/time field data to a text file. For example, the data is: 1/1/2008, but it turned out 1/1/2008 0:00:00 in the text file. I don't want the 0:00:00 appended. Which step I am missing?

Thanks!

 

[RuralGuy]

Use the Format() function to specify any format you want for the date.