Export specification format for date

C

Cecilia R.

hi,

I created an export specification but iam having problems with the date
format. The date format of the data i am exporting is ddmmyyyy (eg 25052007)
however, the text file created always includes the time, thus the format is
showing as 25052007 00000. I want to get rid of the time format. How can i
do that?

Your help will be greatly appreciated!

Thanks
 
O

Ofer Cohen

I had the same problem,
mybe there is another solution but I exported the date as Text, that way the
time wasn't transfer with it.

I assume that the text file treat every thing as text, so it's nt inportant
how you trabsfer this date value, as text or date (if I'm wrong I'll be happy
if someone can correct this assumption)

Export as text field works fine for me, and for the people that recive it
 
K

Ken Snell \(MVP\)

Also can use the Format function to export the data -- using a calculated
field in the query:

ExportDate: Format([DateFieldName], "ddmmyyyy")
 
Top