Problem with Time while sending a form to Excel

Pachi
Pachi Member Posts: 25
edited 2010-04-07 in NAV/Navision Classic Client
Good afternoon,

I'm trying to send to Excel a form with times in it (for example, form 5915) but I'm getting in Excel wrong times.

I'm in Spain working in GMT+1 time zone, and when exporting the form content through "Send To Excel" option, times in Excel sheet are GMT.

Does someone know how to solve this problem?

Best Regards,

Comments

  • kriki
    kriki Member, Moderator Posts: 9,132
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Pachi
    Pachi Member Posts: 25
    Please... someone can help me?
  • einsTeIn.NET
    einsTeIn.NET Member Posts: 1,050
    I think NAV stores time values internally in UTC format and applies your regional settings during runtime. Germany is also in GMT+1 and there seems to be no problem. Which version? Which Style Sheet?
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • Pachi
    Pachi Member Posts: 25
    einsTeIn.NET wrote:
    I think NAV stores time values internally in UTC format and applies your regional settings during runtime. Germany is also in GMT+1 and there seems to be no problem. Which version? Which Style Sheet?

    Version is NAV 2009 ES
    Stylesheet is the standard Excel one.

    Thank you for your interest.
  • jannestig
    jannestig Member Posts: 1,000
    There is hotfix related to date formats for style sheets

    You say you are working in spain, but if you are logging into a server located in the UK or with wrong time setting that would probably explain it.

    Have you tried this on a local DB if you have access to one
  • Pachi
    Pachi Member Posts: 25
    jannestig wrote:
    There is hotfix related to date formats for style sheets

    You say you are working in spain, but if you are logging into a server located in the UK or with wrong time setting that would probably explain it.

    Have you tried this on a local DB if you have access to one

    Yes, I'm experiencing it in my PC with a Cronus database.

    Thanks
  • jannestig
    jannestig Member Posts: 1,000
    so what happens when you copy and paste the lines into excel then ?
  • Pachi
    Pachi Member Posts: 25
    Not, only when using "Send to Excel" button
  • jannestig
    jannestig Member Posts: 1,000
    Hmmm if your cronus is SQL DB have you tried the same thing with a classic DB?

    If you disconnect you PC from the internet & network then try an SQL DB export to excel maybe you will have a difference then, I think its the exchange server that controls time on a domain??

    The point is to see if its a server issue somewhere so an offline export after checking you regional settings could help you narrow down the issue.
  • Pachi
    Pachi Member Posts: 25
    I have experienced the problem in an SQL server installation and in my own PC with the native database.
  • Pachi
    Pachi Member Posts: 25
    Any additional idea?

Categories