Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Programming Microsoft Dynamics NAV Hone your skills and increase your productivity when programming in Microsoft Dynamics NAV 2017

Product type Paperback

Published in Apr 2017

Publisher Packt

ISBN-13 9781786468192

Length 706 pages

Edition 5th Edition

Languages

C/AL

Tools

Dynamics NAV

Concepts

Enterprise Resource Planning

Authors (3):

Marije Brummel

David Studebaker

Christopher D. Studebaker

View More author details

Table of Contents (10) Chapters

Preface

1. Introduction to NAV 2017

2. Tables FREE CHAPTER

3. Data Types and Fields

4. Pages - the Interactive Interface

5. Queries and Reports

6. Introduction to C/SIDE and C/AL

7. Intermediate C/AL

8. Advanced NAV Development Tools

9. Successful Conclusions

Date and Time functions

NAV provides a considerable number of Date and Time functions. In the following, we will cover several of those that are more commonly used, especially in the context of accounting date-sensitive activity:

The TODAY, TIME, and CURRENTDATETIME functions
The WORKDATE function
The DATE2DMY, DATE2DWY, DMY2DATE, DWY2DATE, and CALCDATE functions

TODAY, TIME, and CURRENTDATETIME

TODAY retrieves the current system date as set in the operating system. TIME retrieves the current system time as set in the operating system. CURRENTDATETIME retrieves the current date and time in the DATETIME format, which is stored in UTC international time (formerly referenced as GMT or Greenwich Mean Time) and then displayed in local time. If we are using the Windows...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Marije Brummel

Marije Brummel is a coach, author, programmer, consultant, project manager, presenter, evangelist, and a trainer. Marije has received the Microsoft MVP and the NAVUG All-Star awards, among several other awards. She has chaired the Microsoft Dynamics Credentialing committee and has authored official Microsoft Exam materials. She's the go-to girl for performance troubleshooting and upgrade challenges. One of her biggest achievements was introducing Design Patterns into the Business Central community. Her books, blog articles, and YouTube videos have influenced almost everyone involved with Business Central. She is a mother of five, enjoys the outdoors with her dog and loves spending time with her family.

See other products by Marije Brummel

Christopher D. Studebaker

Chris Studebaker was a certified environmental consultant working with manufacturing facilities to meet national and state regulations before he started working with Business Central (then known as Navision) in 1999. After working on regulatory reporting, data analysis, project management, and subcontractor oversight, Chris has used those skills to sell, develop, and implement Business Central for more than 25 years. He has specialized in retail, manufacturing, job shop, and distribution implementations, mostly in high-user-count, high-data-volume applications. Chris serves as a technical consultant and trainer for customers and fellow Business Central professionals. He has a Bachelor of Science degree from Northern Illinois University and has done graduate work at Denmark Technical University.

See other products by Christopher D. Studebaker

David Studebaker

David Studebaker has been designing and developing software since 1962 as a developer, consultant, manager, and business owner. In 1967, David co-authored the first general-purpose SPOOL system, an AT&T/IBM joint project. He has been a founding partner in several firms, most recently Studebaker Technology and Liberty Grove Software. David's publications include a decade of technical reviews for ACM Computing Reviews and a number of articles on shop floor data collection. David originated the Packt series of books on programming Microsoft Dynamics Business Central (aka Dynamics NAV). He holds a BS in mechanical engineering from Purdue University and an MBA from the University of Chicago. He is a life member of the Association for Computing Machinery.

See other products by David Studebaker