Errors When Exporting Date/time To Excel

[MS1234]

Hi, I have a query in Access with a field called TimeStamp. I want this field to export to excel in DDMMMYY HH:NN

When I set the field's property Format to DDMMMYY HH:NN in the query it shows fine in Access (eg 04Sep18 23:18) but when exporting to excel it gives an error (We found a problem with some content...Repaired Records: Format from /xl/styles.xml part Styles) and it shows as a decimal number.

I want excel to recognize the field as a date (as opposed to using format(TimeStamp,"ddmmmyy hh:nn") which looks fine exported to excel but not recognized as a date.

Can someone help.

Many thanks

 

[arnelgp]

create a similar query without format and export it.

 

[MS1234]

Hi thanks, but can you clarify what you mean there? Note that I'm not using a format function for the query field, I am using the query field's "format" property, so not sure what "create a similar query without formatting" means?
Cheers

 

[arnelgp]

you just copy abd psste the orig query.
rebame the copy, edit and remove the firmat to that field.
use the copy for expirt.
the iriginal for reporting.

 

[MS1234]

I need the field from the query to export in format DDMMYY HH:NN so how do I achieve that.
Thanks