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.