Date – Page 5 – Pardaan.com

The date format is incorrect in an Excel worksheet when you export in excel via RTC Client

Today i created a processing only report in navision classic client which used to pull some data into excel. The format contain the date fields too. Now while running that report from classic client it works great but while running report from RTC client the date…

6 December 2012

Dynamics NAV & BC Tips & tricks

Safely convert a text date to a date

Sometimes you just need to convert a text to a date, here is a function I have created that should do it without generating an error. If the input string is wrong, it will return a blank date. Bron : Magno's Blog Lees meer...

20 November 2012

Dynamics NAV & BC Tips & tricks

How to: Format Date Values

When you create a client report definition (RDLC) layout for a report, you must modify date values so that they are formatted correctly. Use the following procedure to verify or change the format of a date. Before you begin this procedure, you must create a layout…

31 July 2012

Dynamics NAV & BC Tips & tricks

Using GL Setup and User Date Ranges – if using Inventory

Rules · Use GL Setup date range to control access to post inventory · Use User date range to control user’s access to a period overall Bron : Dynamics Queen Lees meer...

25 May 2012

Dynamics NAV & BC Tips & tricks

Using Date Shortcuts

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…

17 April 2012

Dynamics NAV & BC Tips & tricks

Vendors with specific shipping dates

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…

6 March 2012

Dynamics NAV & BC Tips & tricks

Matching Date Formats on Classic and RDLC Report Versions

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. Bron : 1 Click Factory Lees…

13 February 2012