Thread: 1/1/1900 issues
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JAH08886
 
Posts: n/a
Default 1/1/1900 issues

I have dates in an access database represented as 1/1/1900. When I generate
a table query and cut and paste the data from the access query into excel the
1/1/1900 dates are pasted into excel as 1/2/1900. Why is the date being
incremented by one day during the cut and paste procedure. If I export the
data directly from the access query using excel file format the dates export
unchanged. Something in the cut and paste operation is causing an issue.

Any ideas why?