need to get rid of / in dates for export to text

pungentSapling

NeedHotSauce?
Local time
Today, 11:14
Joined
Apr 4, 2002
Messages
116
I need to export a table to a text file ....this is all working fine except for the fact that the dates need to be in yyyymmdd format with no slashes.
I have my TABLE set so it does not show slashes, but when I export the table to the TEXT FILE the slashes appear in the text file.
I have searched the forum and have found similar topics but not similar enough for my humble brain.
thanks
 
Create a query with the expression below for your date field and then export the query to the text file.

format([YourDateField],"yyyymmdd")
 
thanks that seems to work
but why does access insist on adding slashes to the dates at export, even when they are not in the originol table? Not Nice.
Thanks again
 
Actually it is nice. Access doesn't store dates as strings. It uses its own internal format. I don't think many other applications could make use of that. So, in fact, it makes an effort to export dates in a format most systems will understand.
 

Users who are viewing this thread

Back
Top Bottom