Book Image

Programming Microsoft Dynamics NAV

By : David A. Studebaker
Book Image

Programming Microsoft Dynamics NAV

By: David A. Studebaker

Overview of this book

<p>Microsoft Dynamics NAV (formerly known as Navision) is a well established Enterprise Resource Planning (ERP) application, part of the Microsoft Dynamics family.</p> <p>Renowned for its challenging learning curve, Dynamics NAV is a complex piece of software with a unique design structure and, for developers learning to modify or enhance it for vital business purposes, the task can sometimes be overwhelming.</p> <p>This book will ease you through the complexities of NAV application development. You will learn the skills and develop the confidence to tackle your own critical NAV applications. This book will act as your experienced NAV programming mentor, helping you to become productive as a NAV developer much more quickly.</p> <p>From basic NAV terminology and concept definitions, through the essential building blocks of NAV data structure and objects, you will gain an understanding of the fundamental underlying concepts of NAV. You will learn practical details about NAV object construction and the tools available, including the Table, Form, and Report Designers. You will learn how to use NAV's tools to effectively navigate through the various features of objects, including properties, triggers, and C/AL code and receive practical guidance on ways to develop and test in the unique NAV C/SIDE development environment.</p> <p>A section on software design for NAV is provided along with tips for efficient design of a new NAV application or enhancing an existing application. With its comprehensive collection of NAV information, this book is not only designed to help you learn, but can act as a reference as well.</p>
Table of Contents (17 chapters)
Programming Microsoft® Dynamics™ NAV
Credits
Foreword
About the Author
About the Reviewers
Preface

DATE Functions


In order to convert numeric data to Date data types and Dates to numeric data, C/AL uses a series of Date functions.

DATE2DMY Function

DATE2DMY allows you to extract the sections of a date (Day, Month, and Year) from a Date field. The syntax is as follows:

IntegerVariable := DATE2DMY ( DateField, ExtractionChoice )

The fields IntegerVariable and DateField are just as their names imply. The ExtractionChoice parameter allows you to choose which value (day, month, or year) will be assigned to the IntegerVariable. The following table provides the DATE2DMY extraction choices:

DATE2DMY Extraction Choice

Integer Value Result

1

2 digit day (1- 31)

2

2 digit month (1- 12)

3

4 digit year

DATE2DWY Function

DATE2DWY allows you to extract the sections of a date (Day of the week, Week of the year, and Year) from a Date field. The syntax is as follows:

IntegerVariable := DATE2DWY ( DateField, ExtractionChoice )

The fields IntegerVariable and DateField are just as their names imply...