outputto date/time

[stephenaa5]

Hello. I have an export from Access to XLS that works just fine except for one irritation. The data in Excel comes out as DATE, where the live data is DATE-TIME. It's easily fixed in Excel by changing the column formats (data is retained), but this is a PITA for users.

Any suggestions?

I'm currently just using


Docmd.Outputto acoutputquery, "payrollapproval", acformatXLS


Works like a charm, excepting the formatting.

Thanks in advance!

Stephen.

[rpeare]

in your output query are you specifically setting a format in the export?

have you tried something like

ExportDateConv: format([TestDate], "General Date")