Problem outputting rpt to spreadsheet - dates are wrong format

[GaryEllis]

I have a macro that emails a report to my users. I save the report to a
spreadsheet using Output Format = Microsoft Excel 97-2003. The problem I
have is with the dates (data type=Date/Time). These getting converted to an
integer date in the spreadsheet.

This process worked correctly in Access 97.

 

[Steve Schapel]

Gary,

I am not sure whether this will help or hinder, but I suggest you try
using the Format function, either in the query that the report is based
on, or in the Control Source of the relevant textboxes on the report, to
output the dates in a relevant structure, for example
Format([YourDateField],"dd\-mmm\-yy")