Export problems

[Riaang]

Hi there,

Maybe someone can give me some help with the following.

When I export a query to a text file and it contains dates then the text file shows the date and time but on the query only the date. I did choose short date on both the tabbles and query but still it gives e the times on my text file.

How can I get rid of the time in my text file?

Thanks

 

[giacomo]

if you use the FORMAT function you can get rid of the time...

FORMAT([MY_DATE],"MM/DD/YYYY")

 

[Riaang]

I will try it, thanks for your help