I do a report that uses an Access report that is downloaded into Excel for
presentation. The report is essentially a list of warranty claims,
containing individual claim information including open and close dates. A
problem was pointed out to me in the Excel report, though- the open and close
dates are all listed as 2005 dates, which is incorrect since most of the
claims were opened in 2004. Excel is systematically stating these dates as
the same month in 2005, for example 10/2005 instead of 10/2004. The query
that the Access report uses is pulling correct data, and the report in Access
is correct, the error dates show up after I download the report into Excel
from Access.