Date – Page 4 – Pardaan.com

Convert date string containing a month text value to a date value

Assuming you want to enter date values in the RTC client like 15-MAR-14. that won’t work. date values are only accepted with syntax like 15.03, 15.03.14, etc. But it can be that users prefer the above syntax. so then you can use a text field in…

22 December 2014

Dynamics NAV & BC Tips & tricks

NAV AS 101 Lesson 10: Comparison Period v. Comparison Date

NAV Account Schedules uses a curious convention to determine periods of time in the column layout. The default option if you open account schedules for the very first time is Comparison Date, but I always recommend NAV users use the other option, Comparison Period. Let’s talk…

21 May 2014

Dynamics NAV & BC Tips & tricks

Date formatting

We all learnt that the date format in Navision forms and reports are controlled by the date setting in the regional setting in Windows. No big surprise there. Bron : Navitrail Lees meer...

31 March 2014

Dynamics NAV & BC Tips & tricks

Why Posting Date Errors Occur in Microsoft Dynamics NAV

A user may receive an error such as the following when posting a transaction in Microsoft Dynamics NAV: Bron : ArcherPoint Lees meer...

20 February 2014

Dynamics NAV & BC Tips & tricks

How Do I: Instruct my Bank to Execute Payments Based on Due Date in Microsoft Dynamics NAV 2013 R2

This video demonstrates how to instruct your Bank to Execute Payments Based on Due Date in Microsoft Dynamics NAV 2013 R2. Bron : Microsoft Dynamics NAV Lees meer...

17 February 2014

Dynamics NAV & BC Tips & tricks

Why do all new Microsoft Dynamics NAV Production Orders have an Ending Date of 12/31/XX?

Around the middle of January every year, I can count on getting questions on why all of the new Dynamics NAV Production Orders that are created have an Ending date of 12/31/XX. The answer is quite straightforward: The Work/Machine Center Calendars need to be calculated for…

9 January 2014

Dynamics NAV & BC Tips & tricks

Date Components

You think you know exactly how the date functions DATE2DMY and DATE2DWY in C/SIDE work, don’t you? So did I, but take a look at the following example. Things are more complex than I thought, and C/SIDE is cleverer than I anticipated. Bron : Zen &…

30 August 2013