Problem outputting rpt to spreadsheet - dates are wrong format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
Back
Top