TransferText , date and time format (1 Viewer)

Leo_Polla_Psemata

Registered User.
Local time
Today, 11:26
Joined
Mar 24, 2014
Messages
364
Hi , i try to export a .txt file using DoCmd.TransferText method,
the problem is that the date time format on the txt must be ddmmyy , hhnn
Once i export, the format is different.
See the below image.
Do you have any idea how can i make it ?
Export txt and keep date time format as in the query ?

 

GinaWhipp

AWF VIP
Local time
Today, 14:26
Joined
Jun 21, 2011
Messages
5,899
You have to set the Format in the query first, then transfer out. If you have already done so please post the SQL of the query.
 

Leo_Polla_Psemata

Registered User.
Local time
Today, 11:26
Joined
Mar 24, 2014
Messages
364
FORMAT(NOW(),"yyyymmdd")

Okay, understand, set the Format means that I have to use the above in the sql
 

Users who are viewing this thread

Top Bottom