Date Change When Importing Data from Oracle

Question

Date Change When Importing Data from Oracle

Kamal Al Tawil 1

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

1 answer

Your answer

Answer 1

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.

Kamal Al Tawil 1 Reputation point

2022-05-10T05:38:42.713+00:00

Dear @Emily Hua-MSFT ,

The issue is not in changing the format from Oracle report, it is easy.
But we have hundreds of customized reports (aged 15+ years ago) should be updated to do that.
Moreover, there are hundreds of Oracle fixed system reports (Oracle EBS) that we are not eligible to update them, also have the same issue.

I think there should be a fix for this bug since all systems have the same issue.

Regards,
Kamal
Emily Hua-MSFT 27,796 Reputation points

2022-05-12T09:40:53.877+00:00

Hi @Kamal Al Tawil

Thanks for the detailed explanation.
I understand that you need a solve this issue before or during the process of importing data to Excel.
Since I do not have the test environment, and I can only reply to you through the forum, it would be best to open a support ticket with Microsoft Support to help review your issue and help you test remotely.

I also suggest you to post a new thread in the Oracle forum to check if there is any other settings on Oracle.

Thanks for your understandings again. If there is any update on this issue, welcome to share with us as well.

Share via

Date Change When Importing Data from Oracle

1 answer

Your answer