NULLDATE ER function

The NULLDATE function returns a Date value that represents the null date (January 1, 1900).

Syntax

NULLDATE () as 

Return values

Date

The resulting date value.

Example 1

DATEFORMAT (NULLDATE(), "yyyy-MM-dd") returns the null date, January 1, 1900, as "1900-01-01", based on the specified custom format.

Example 2

The expression IF( Invoice.DocumentDate = NULLDATE(), true, false) returns True when the value of the DocumentDate field equals the null date. In this example, Invoice is an Electronic reporting (ER) data source of the Finance/Table records type, and it refers to the CustInvoiceJour table.

Additional resources

Date and time functions