Hi,
I have a report based on a query that uses a few calculated fields using dates. When I export the report to Excel, these fields/columns are not recognized as dates by Excel. I can set the format to Short Date in the query but not the report. The format option in the property sheet is blank. All the fields that are not formulas are set to Short Date. How do I fix this?