Can we change the Date format in Navision

AKHIL · 2009-06-02

Hi All,

I want to change date format in Navision database without based on Regional Settings.
i would like to know that 'Without depends on Regional settings, Navision itself has a setup for changing Date format or not '.
Whatever the date format in system ,i dont want to consider it , i can give my own setup in Navision. it should be displayed in my NAV Database. this feature is available in navision or not , suggest me

Regards
AKHIL

jannestig · 2009-06-02

Where do you want to change the format? In every field on every form etc or just on reports. There is a property of a tables fields called
DATEFORMULA that could be used, But in General there is no such tool to set the format.

Why do you need to change the format to be different from your current local settings ?

DenSter · 2009-06-02

AKHIL wrote:

i would like to know that 'Without depends on Regional settings, Navision itself has a setup for changing Date format or not '.

No there is no such setting in NAV, it picks up on regional settings. You can modify the format of individual date fields on forms, but to do that for all date fields would not be practical. Besides, you don't really want to do that anyway. When you roll out your product anywhare, the users expect the dates to be formatted the way that they are used to.

slmaluwa · 2009-06-02

Best option is change Regional Settings of all windows users using a SCRIPT or Group Policy or something (Sorry, I don't have any: Me too looking for a better script in this regard).

DenSter · 2009-06-02

Why would you want to do that? Why would you force someone in the US for instance to use European regional settings, when the application will work without any problems in their own regional setting? I don't understand the reasoning why you would want to do such a thing.

Can we change the Date format in Navision

Comments

Categories