I have a query that I am exporting and need to keep the format a certain way.
the date needs to look like this
20090707 for July 7, 2009
I have the format correct in the query but when I export it it turns to this.
7/7/2009 1:47:58 PM
Same with the time - I have it set to HHMMSS
hour minute second
and when exporting I get