Romeo
November 27, 2009, 8:16am
1
eventhough my date format in the control panel is DD/MM/YYYY, the year is displayed as YY (only 2 digits)
unless the posting date is starting from 01/01/2030, it is shown as YYYY
is there a way to display all the time the 4 digits relative to the year?
admin1
November 27, 2009, 8:28am
2
This is Navision’s standard. You have to manually change the format on all reports and forms if you need it to be like YYYY.
Romeo
November 27, 2009, 8:32am
3
i meant to see date values in the forms, such as journals and entry tables
It is “only” when using years from 1930 till 2029; outside that range NAV shows 4 digits.
I would like the possibility to decide that myself…
DRB
November 27, 2009, 8:33am
5
If the year is between 1930 to 2029, then it will be shown in 2 digits otherwise in 4 digits.
admin1
November 27, 2009, 8:41am
6
Yes and you can change the format manually by changing the value of the “Format” property of the date fields.
Example you can just enter: <Day,2>-<Month,2>- then you dates are displayed as DD-MM-YYYY
admin1
November 27, 2009, 8:44am
7
And you might also be able to do the change as a general change directly in FIN.STX - but it might require that you need to have the file “locked” by Microsoft to support it (or someone else who knows how to do this)
Romeo
November 27, 2009, 9:13am
9
A friend of Mine gave me a much quicker solution:
go to control Panel==>Regional Settings
in the date tab, there is a section called “calendar”
when a 2 digit year is entered, interpret it as …
it is set to be from 1929 till 2029
reduce the value to 2000 for ex and things in NAV will become just fine
sander7
November 27, 2009, 9:18am
10
You just have to remember that changing the regional settings only have effect on that particullar PC.
If you want this to be “global” you have to make the same change on each and every PC that connects.
The solution with formatting how date are shown, works “out of the box” for all users, regardless of local settings.
Hy Romeo
With this case how can I do it?
FORMAT(“Purchase Header”.“Document Date”,0,4)
Thanks
Romeo
December 28, 2009, 2:21pm
12
i’m not sure how to describe the solution,
but you can try one of the given solutions given in this page (either the control panel on each PC or the format)