How to Empty a DateTime Field in Business Central (AL)

Sometimes, you may need to clear or reset a DateTime field in Business Central. There are two correct ways to do it in AL code.

Table of Contents

Method 1: Assign a Zero DateTime

Following syntax AL program allowed you to assign zero date time

DateTimeField := 0DT;

This sets the field back to a blank or uninitialized state.

Second method to clear the Date Time field value for Business Central AL Program is as follows

CLEAR(DateTimeField);

This also removes the stored value and resets the field to its default (empty) state.

Many developers try to clear the field using an empty string, like this:

DateTimeField := '';

This would not work it will cause an error because an empty string (”) isn’t a valid DateTime value.

Tip: Always use 0DT or CLEAR() when you want to empty a DateTime field in AL. Both methods are valid, reliable, and error free.

Following are the important FAQs related to how to Emptying a DateTime field in Business Central.

How can I clear a DateTime field in AL?

You can clear it using either of these 2 methods and the same steps defined this post.

What does 0DT mean in AL?

0DT represents a blank or default DateTime value – similar to “no date/time assigned.”

Can I use an empty string (‘’) to clear a DateTime field?

No. Assigning an empty string to a DateTime field will cause an error because a string value isn’t valid for a DateTime data type.

Which method is better – 0DT or CLEAR()?

Both are correct. Use 0DT when you want to directly assign a value, and CLEAR() when you’re resetting a variable or field.