Date Change When Importing Data from Oracle

Kamal Al Tawil 1 Reputation point
2022-05-09T07:48:04.9+00:00

Dears,

I have a problem when importing dates from Oracle when date is after 2029 Excel converts it to 1900s (2050 --> 1950).
I checked the below link with no help where the updates help in typing the date not importing it:
https://learn.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers

There should be a solution where we have hundreds of reports having the same problem with the end users.

Can you advise?

Regards,
Kamal Al Tawil
Analyst Developer Lead
FDC

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,591 Reputation points
    2022-05-10T02:22:22.807+00:00

    Hi @Kamal Al Tawil

    Welcome to Q&A forum ~

    As I do not have the Orcale environment to test for you, following information is seached from Internet, hope it could be helpful.
    Thanks for your understandings.

    Your issue may be caused by the different principles of Excel and Oracle for date data storage.
    For Excel, we can refer to "Dates And Times In Excel".

    • I suggest you try to convert Oracle date as a number that Excel can understand. Here is a link "Return Oracle Datetime as 'Excel' Number" you can have a look.
    • Aafter exporting data from Oracle to Excel, you can also try using Excel formulas or VBA code to convert the "date", similar thread is "How do I convert Oracle internal date to Excel date in Excel?". If there are any further Excel formula issues, welcome to shared your data sample (The "date" shown on workbook, and the correct date) here, I would try my best to help you. If you need the help on VBA to batch convert "date" to correct date, it's recommended to post a new thread with details and the tag "office-vba-dev" on Q&A forum. There will be VBA experts to share their experience kindly.

    (Please Note: Since the web sites above are not hosted by Microsoft, the links may changed without notice. Microsoft does not guarantee the accuracy of this information.)


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.