P
Patrick Lamb
Why is it when I highlight my table and select analyze
with excel, if I have a date of 01/01/1900 it shows in
excel as 02/01/1900? I am using office 2000.
To reproduce create a table with a field
called 'testdate' with datatype datetime. Enter 4 rows
into the table, 01/01/1900, 02/01/1900, 01/01/1920 and
01/10/2003. Highlight the table and select analyze with
excel. When the dates appear in excel the first two
dates are 1 day on and the last two dates appear fine.
Why?? How can I make sure that when the date 01/01/1900
transfers to excel it transfers as 01/01/1900 not
02/01/1900??
with excel, if I have a date of 01/01/1900 it shows in
excel as 02/01/1900? I am using office 2000.
To reproduce create a table with a field
called 'testdate' with datatype datetime. Enter 4 rows
into the table, 01/01/1900, 02/01/1900, 01/01/1920 and
01/10/2003. Highlight the table and select analyze with
excel. When the dates appear in excel the first two
dates are 1 day on and the last two dates appear fine.
Why?? How can I make sure that when the date 01/01/1900
transfers to excel it transfers as 01/01/1900 not
02/01/1900??