time format for 'txt' export file problem

[russi]

Morning!

I am exporting Access 97 database to delimited 'txt' format.

Dates are NOT to have a '/' or other separater between month, day, and year. Problem is that the date field obviously includes the time, which IS fine.

BUT the software that is going to read this file requires that the time numbers butt against the date numbers AND that if the time is 8:09:00 that it actually shows as 08:09:00

Ideas? There are thousands of records involved.

Russ

 

[BLeslie88]

My Approach...

I use the Left(Var,2) & "- or / or :" & Mid(Var,3,2) & "- or / or :" & Right(Var,2)...

I format dates and time like this because I work with many systems that do not use the same formats. So I code the formats in a string and feed which ever system the way it wants it.... But this is just my approach.

Regards,
Brian

 

[antomack]

Build a query and format your date field in whatever way you require and then export the query rather than the table. The text file should hold the formatting as in the query. To suit your needs try

Format([YourDateField],"mmddyyyyhh:nn:ss")