Display ISO8601 date format in Navision and on reports?

bardoz

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

ClausHamann

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

bardoz

Thanks! That did indeed solve my problem.

Although the solution was slightly amusing