Most NAV users are familiar with some basic Date shortcuts in NAV such as typing in T for today’s date, W for the work date, and 032012 for 03/20/2012.
Did you know that there are actually many more date and time shortcuts that NAV supports? Here is a comprehensive list:
How to model a vendor where they only ship on Wednesdays? This is just an example …
That is something we need to be careful with. First of all, keep in mind the difference with Sales. In there, we have the “Shipping Agent” where we can define an “Agent Service” (F5790).
When trying to match date formatting on the classic and RDLC versions of a report, you might run into an issue of mismatched date formatting. This can be corrected by forcing the same date format on Classic and RDLC reports.
For a recent project, I needed to export the object properties of a number of objects to an XML file.
As you know, in the Object table, there are separate columns for Date and Time. Initially, I exported each column as an individual XML attribute, using the FORMAT function’s standard format #9 to XML-format the values
Date filters on custom made forms are a common request. Apparently I’ve been coding it wrong the past years… until today of course! Maybe my biggest mistake was that I never bothered to look at how standard Nav handles this.
Vertalen
