Display ISO8601 date format in Navision and on reports?

bardoz
bardoz Member Posts: 3
edited 2006-11-20 in NAV/Navision Classic Client
Hi!
I work for an international company. To minimize confusion on date formats we have decided to adopt ISO8601 as a company standard date format; that is YYYY-MM-DD. For example today is 2006-11-20.

I understand that it is the Regional Settings on the client computer that determine how dates are displayed in Navision. I have set my regional settings short date format (WinXPpro) to yyyy-MM-dd. But what I get in Navision is YY-MM-DD, displaying today's date as 06-11-20. When asking our Navision partner/supplier about this they say it is not possible to display YYYY-MM-DD in Navision without significant customization. Is that correct? Seems to me this should be a simple enough configuration setting somewhere.

I also asked our Navision partner/supplier if we could get the dates on reports in ISO8601 format; again the answer was no. That would require customization of each and every report. Again, I would have thought this was a relatively simple thing to solve.

Kind regards,

Thomas

Comments

  • ClausHamann
    ClausHamann Member Posts: 80
    Hi Thomas

    The issue is that Navision only shows two digits if the year is within the "two digit" year range setup on the Date page of the regional settings.

    I don’t know if you can use this but try to change this date range back in time, e.g. 1800-1900. All years after 1900 will now be shown with four digits in Navision.

    Regards

    Claus
    Claus W. Hamann

    http://www.AcumenConsulting.co.nz
  • bardoz
    bardoz Member Posts: 3
    Thanks! That did indeed solve my problem.

    Although the solution was slightly amusing :)

Categories