Dynamics NAV and Date Formats

• General Date Formats are controlled by your machine's regional settings
• Regional Settings>Format>English (United States) Allows 
• Short Date: dd-mmm-yy
• What will not work
• Default dates displayed by your excel when exporting data
• Excel AND NAV will not display mmm by default, and will instead display mm
• You can manually change the formatting on the cell, but the cell will not originally default to any mmm date format
• Eg. short date 31-jan-18 will display in excel by default as 31-01-18
• Long dates on the other hand will display correctly dd-mmm-yy if you set the default long date format in the regional settings to dd-mmm-yy
• You Cannot mix - and / separators in the date
• Excel and NAV will use the first separator character they find
• Eg. Windows date format 31-Jan/2019 will display by default as 31-01-19
• What will be affected
• Dates displayed in SQL server
• Dates displayed in NAV if NO Language pack is installed
• Default W1 uses en-US, but is not a language pack
• If you change the regional settings on the machine, you must restart the NAV instance for it to detect the new format
• NAV Date Formats
• Are controlled by the Language Pack
• Default EN-US: DD/MM/YYY