Top 5 This Week

Related Posts

How To Empty A Datetime Field ?

You have 2 methods to empty value in a datetime field.
First method is:
DateTimeField = 0DT;
Second method is
CLEAR (DateTimeField);
A common mistake make when trying to clear value in datetime field is to assign empty string to the datetime field.
DateTimeField = ”;
This code will not work and you will get an error message.

Jubel Thomas Joy, a 16+ year Microsoft Dynamics 365 Business Central/NAV/Navision expert, founded "Navision Planet" in 2009. Certified in Business Central , D365 - Commerce and many more. He blogs on the latest updates and various modules of Business Central & LS Central, showcasing expertise in SQL, Microsoft Power Platforms, and over 150 organizations of work experience.


Please enter your comment!
Please enter your name here

Popular Articles