Skip to Main Content
  • Questions

  • The date That appears on the Grid is different than the one downloaded

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, ahmad.

Asked: December 10, 2020 - 8:30 am UTC

Last updated: December 17, 2020 - 5:01 am UTC

Version: 20.2

Viewed 1000+ times

You Asked

Dear Tom ,

When Downloading the data from interactive Grid it gives me wrong date (the date on excel is different from the one that appears on the grid)
It Gives me 1905 for the year

would you please inform me how to solve this problem

Thank You

Best Regards

Update:-

a simple example is as follow:- in my program the customer order date as it appears on the browser is "10-12-2020' when downloaded to excel the order date is "12-07-1905"

Please note that this happened using web browser on windows XP

and Connor said...

Please put together a simple example of apex.oracle.com and then send us the link by updating this question

You date is probably stored incorrectly.

12th July 1905 is 2020 days after Jan 1st 1900. So the *number* 2020 is going down into Excel, and becoming 12th July 1905

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

The reason

Ahmad Hussein, December 17, 2020 - 7:05 am UTC

When download the file from Goggle Chrome on android , no problem appears and the date is correct.

SO THAT THE DATE STORED CORRECTLY FOR SURE AND APPEARS ON THE SITE CORRECTLY THE PROBLEM APPEARS ONLY WHEN DOWNLOAD FROM WEB BROWSER ON WINDOWS XP


Thank You

Best Regards
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.