Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Programming Microsoft Dynamics 365 Business Central

You're reading from   Programming Microsoft Dynamics 365 Business Central Build powerful, robust, and scalable extensions customized for your business requirements

Arrow left icon
Product type Paperback
Published in Oct 2024
Publisher Packt
ISBN-13 9781803236414
Length 466 pages
Edition 7th Edition
Arrow right icon
Authors (4):
Arrow left icon
David Studebaker David Studebaker
Author Profile Icon David Studebaker
David Studebaker
Marije Brummel Marije Brummel
Author Profile Icon Marije Brummel
Marije Brummel
Natalie Karolak Natalie Karolak
Author Profile Icon Natalie Karolak
Natalie Karolak
Christopher D. Studebaker Christopher D. Studebaker
Author Profile Icon Christopher D. Studebaker
Christopher D. Studebaker
Arrow right icon
View More author details
Toc

Table of Contents (11) Chapters Close

Preface 1. Chapter 1: Introduction to Business Central 2. Chapter 2: Tables FREE CHAPTER 3. Chapter 3: Data Types and Table Fields 4. Chapter 4: Pages – The Interactive Interface 5. Chapter 5: Reports and Queries 6. Chapter 6: Introduction to AL 7. Chapter 7: Intermediate AL 8. Chapter 8: Extensibility beyond AL 9. Index 10. Other Books You May Enjoy

Date and time methods

Business Central provides many date and time methods. In the following sections, we will cover several of those that are more commonly used, especially in the context of accounting date-sensitive activity:

  • Today, Time, and CurrentDateTime methods
  • WorkDate method
  • Date2DMY, Date2DWY, DMY2Date, DWY2Date, and CalcDate methods

Today, Time, and CurrentDateTime methods

Today retrieves the current system date. Time retrieves the current system time, as set in the operating system. Both Today and Time are influenced by the time zone client setting.

CurrentDateTime retrieves the current date and time in the DateTime format, which is stored in UTC international time (formerly referenced as Greenwich Mean Time (GMT)) and then displayed in local time. The syntax for each of these is as follows:

DateField := Today;
TimeField := Time;
DateTimeField := CurrentDateTime;

These are often used for date- and time-stamping transactions or for filling...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
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
Renews at $19.99/month. Cancel anytime
Banner background image