Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Toad When using Save As XLS to export and the date is 1/1/1900 or 1/2/1900 then the date exported into Excel will increment by 1 day.
Steps to reproduce the issue: 1. Add or modify the date to any table to be 1/1/1900 or 1/2/1900. 2. Save As XLS File. 3. Open the Excel file and you will see the date of 1/1/1900 as 1/2/1900 and 1/2/1900 as 1/3/1900.
해결 방안
Use Save As XLS Instance to export into Excel.
This is a documented Microsoft Bug. Microsoft assumes that the year 1900 is a leap year. For more information about this bug please go to the following link: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q181/3/70.asp&NoWebContent=1
