Date Formats When Exporting to CSV

[Joe4]

I have a query which I am exporting to a CSV file. I have some date fields. In the Query Designer, under Properties of these fields, I set their format to a custom format of mm/dd/yyyy so that when viewing the query, today's date would show up like: 09/28/2006

However, if I export the file to a CSV file, in the file the date appears like:
9/22/2006 0:00:00

Is there a way to get it to export in the same format I have it displayed in (i.e. 09/28/2006)?

I know I can use the FORMAT function and use "mm/dd/yyyy" as my format, but the potential problem with that is that converts it to a Text format, which means if have a Text Qualifier set, it surrounds this value with the Text Qualifier, even though it is supposed to be a Date field and not a Text field (so my value exports as "09/28/2006" instead of the desired 09/28/2006).

Thanks.

 

[Andrew Fergus]

Hi

If you are using the menu option File > Export > csv > Export then when the next dialogue box appears click 'Advanced' and you should see an 'Export Specification' dialogue box. There is an option to include leading zeroes in dates but this won't make the time go away. As you are aware you can remove the time using the Format function, but you can also remove the text qualifier within that 'Export Specification' dialogue box.

HTH, Andrew

 

[Joe4]

Thanks for the reply Andrew.

I was just curious if there was an easy to get rid of the time piece without making it text, as removing the Text Qualifiers will also remove them from the "real" text fields.

Through testing, it looks like the program we are sending to will accept text qualifiers around the date, so I'll probably just end up using the FORMAT function.